Trellis
The Trellis chart& is a network of small charts. It is a repetition of a chart across a grid. Generally, minimum two dimensions are used, one for the grid variable and another for the x-axis within each small chart. Users can analyze the metrics within each chart without a query (a selection) and compare with the rest of the group at the same time via a trellis chart. A chart will be shared on the same Y-axis, so it becomes easier for users to identify irregular behavior among the variables by accurately comparing the metrics across the grid.
Default Chart Image
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FaHecly3wC8RTzAidM5pK%252FDefault%2520Chart.png%3Falt%3Dmedia%26token%3Df9cc06f1-4332-4e8e-b518-ebd089dbdc0c&width=768&dpr=4&quality=100&sign=6b912c55&sv=1)
Best Situations to Use a Trellis chart
To analyze text data
To identify trends and patterns that would otherwise be unclear or difficult to see in a tabular format.
Properties of the Trellis chart
Background: The user can change the background color of the chart, can get the border for the chart and can change the border color, can get the reflection of the chart by enabling the shadow option can also change the color and increase & decrease the transparency of the shadow.
Export Options: The user can enable the “Enable Context Menu”, then it is possible to download the reports in different formats if we click on the chart from the preview section. The heading and sub heading of that downloaded chart and the name of the downloaded file can be change from this section.
General: The user can change the height, width, top, left, chart type, column type & Line form. In this case, we have changed the scroll view to disable.
Merge Series: The user can enable the merge series, can change the chart type & column type, Increase the column width.
Styles: The user can enable the horizontal line and change the color for horizontal & vertical lines, can change the font size, font color, text style, etc.
Subtitle: The user can enable the subtitle to display the second title. The user can change the Name, Font color, size, style for the subtitle.
Title: The user can change Title Name, Font color, size, style, etc.
Dataset Properties Tab
Trellis chart variants by changing the Properties
Trellis Chart with Plain Base and Drawing Horizontal mode
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FwiEunJXHbgRWvP80JEjl%252FPlain%2520Horizontal.png%3Falt%3Dmedia%26token%3D93e3b3fe-4367-4b88-8495-0a1a2a8cbc6d&width=768&dpr=4&quality=100&sign=126372ad&sv=1)
Trellis Chart with Rectangle Base and Drawing Horizontal mode
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252Fbgpa6iqE5re1FNSql3ib%252FRectangle%2520Horizontal.png%3Falt%3Dmedia%26token%3D15a06471-5c7b-4777-818e-a44319bc9a76&width=768&dpr=4&quality=100&sign=7549c936&sv=1)
Trellis Chart with Gradient1 Base and Drawing Horizontal mode
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FMdAqk5SrW0GdSKFrjOR8%252FGradient1%2520Horizontal.png%3Falt%3Dmedia%26token%3D0668d27f-75ad-4587-ad2a-af1498fcc5ae&width=768&dpr=4&quality=100&sign=f76abf6e&sv=1)
Trellis Chart with Gradient2 Base and Drawing Horizontal mode
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252Fry8FkbKPKMrIpM4Jw1cd%252FGradient2%2520Horizontal.png%3Falt%3Dmedia%26token%3Ddf0d0442-5462-4747-91e4-9b9af66a8900&width=768&dpr=4&quality=100&sign=6d71f6f7&sv=1)
Trellis Chart with Gradient3 Base and Drawing Horizontal mode
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FP3NLC55CxmKRvWBs68YY%252FGradient3%2520Horizontal.png%3Falt%3Dmedia%26token%3De832e2f9-82b5-42a7-8dd0-764bbae9e9d0&width=768&dpr=4&quality=100&sign=42536c71&sv=1)
After Changing the Merge Properties
Trellis with Line chart
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FSz1c3VnR4eODYS7iLOCe%252FTrellis%2520Line%2520type.png%3Falt%3Dmedia%26token%3Dc28fd93e-5599-407f-abdc-1f4b0d848da9&width=768&dpr=4&quality=100&sign=62f77517&sv=1)
Trellis with Bar chart & Stacked column
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252Fxub53BQwGuXAVkH8C4I3%252FTrellis%2520with%2520bar%2520chart%2520stacked.png%3Falt%3Dmedia%26token%3D06ad40c2-fdb0-4cf1-8df1-730bc0b5b6a7&width=768&dpr=4&quality=100&sign=de73c591&sv=1)
Trellis with Bar chart & Clustered column
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252F9LdttYAIAq5qn3oa1LdE%252FTrellis%2520with%2520bar%2520chart%2520clustered.png%3Falt%3Dmedia%26token%3D1e3e5d6b-64fd-4336-946a-6db39c44bae0&width=768&dpr=4&quality=100&sign=89376b6f&sv=1)
Trellis with Bar chart & Overlaid column
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FT77JNt9dIOH408ugDuaV%252FTrellis%2520with%2520bar%2520chart%2520overlaid.png%3Falt%3Dmedia%26token%3De9218883-6dfa-487f-9339-56171103cbdb&width=768&dpr=4&quality=100&sign=316f1023&sv=1)
Trellis with Bar chart & 100% column
Trellis with Column chart & Stacked column
Trellis with Column chart & Clustered column
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FMnig5IM0qXxJDToNdCdR%252FTrellis%2520with%2520column%2520Clustered.png%3Falt%3Dmedia%26token%3Dea07eaa4-70ed-4a4e-a574-cbddde6bfff0&width=768&dpr=4&quality=100&sign=45db3a98&sv=1)
Trellis with Column chart &Overlaid column
Trellis with Column chart & 100% column
Trellis with Shape chart
Sample Data
Download the given sample data and map it as mentioned below to plot your Trellis chart:
Use the Year column as Row, Subject column as Column, t1 and t2 columns as Series, and category column as Category to plot the chart as given-below: