Your search needs at least one attribute and one measure to be presented as a chart. When you choose to display your answer as a chart, Trends AI will assign it the best-fit chart type.
Colors are maintained across searches within a session. For example, when doing a search on revenue by state, each state will keep the color assigned to it, even if you change the search or chart type.
You can choose from a large number of chart types in Trends AI. Each chart type provides you with a different visualization for your answer. You can also adjust the axes, labels, and view of the chart.
Choosing a chart
Some chart types may not be available, depending on the columns in your search. For example, if your search does not contain at least one geographical column, then you will not be able to select any of the geo chart types. Trends AI shows unavailable chart types as grayed out.
Column charts: The column chart is one of Trends AI's simplest, yet most versatile chart types. The column chart is often the chosen default chart type, and displays data as vertical columns.
Stacked columns: The stacked column combines the different secondary dimensions into a single column, stacking them.
Bar charts: The bar chart is nearly identical to the column chart. The primary difference is that it displays data as horizontal bars.
Stacked bar charts: Just like stacked columns, stacked bars combine the different secondary dimensions into a single stacked bar.
Line charts: Like the column chart, the line chart is one of Trends AI's simplest, yet most versatile chart types. More often than not the line chart will be chosen as your default chart type.
KPI charts: When you search a single measure, such as
Sales, Trends AI automatically creates a KPI chart displaying the topmost value of that column. Add a time-related keyword to your Search to view a sparkline visualization of your key performance indicator.Pie charts: The pie chart is a classic chart type that displays your search in a circle. The pie chart Trends AI shows is in the shape of a doughnut.
Area charts: The area chart is based on the line chart, but has filled-in regions.
Stacked area charts: This option stacks the values of one dimension on top of the other, enabling you to clearly see the relative volume of data under the line. Contrast this with the presentation in the area chart, where data for different overlaps.
Scatter charts: The scatter chart is useful for finding correlations or outliers in your data.
Bubble charts: The bubble chart displays three dimensions of data, with each containing a set of values.
Pareto charts: The Pareto chart is a type of chart that contains both columns and a special type of line chart.
Waterfall charts: The waterfall chart is used to show how an initial value is affected by a series of intermediate positive or negative values.
Treemap charts: The treemap chart displays hierarchical data as a set of nested rectangles.
Heatmap charts: The heatmap chart displays individual data values in a matrix following a color scale.
Line column charts: The line column chart combines the column and line charts.
Stacked line column charts: The stacked line column chart combines line and stacked column charts.
Funnel charts: The funnel chart shows a process with progressively decreasing proportions amounting to 100 percent in total.
Geo charts: There are three geo charts that let you visualize geographical data in Trends AI: area, bubble, and heatmap.
Pivot tables: Pivot tables in Trends AI use the well-known drag-and-drop interface. Creating a pivot table enables exploring an alternate visualization of data in a wide table. The basic idea is that some data is easier to consume when laid out horizontally, while others are vertically.
Sankey charts: Sankey charts show a flow from one set of values to another, usually with visual emphasis (brighter colors or larger bandwidths) for comparison of the values (for example, top cities in terms of sales might be emphasized).
Radar charts: Radar charts display multivariate data on a two-dimensional chart of three or more quantitative variables that plot on axes (spokes) that originate at the same point.
Charts with multiple measures on the y-axis
You can have multiple measures on the y-axis of many charts, which is a great additional way of presenting information in a chart. A stacked column chart displays the measures stacked in the same column, while a column chart displays the measures side by side.
The following charts support multiple measures on the y-axis:
Column charts
Stacked column charts
Bar charts
Stacked bar charts
Area charts
Stacked area charts
Waterfall charts
Line charts
Line stacked column charts
Make a copy of a chart
You can create a copy of a chart if you would like to make edits without changing the original chart. When saving, you can type in a different name for your copy.
Select Charts on the top navigation bar.
On the Chart list page, select the chart you would like to edit a copy of.
Open the More menu icon (3 dots) and select Make a copy.
Trends AI takes you to a copy of the chart, with “Copy of” added to the beginning of the title.
Make any changes you want to the chart.
Open the More menu icon (3 dots) and select Save.
The Save Chart dialog appears.
Change the name and description, as needed, and select Save.
When you navigate back to the Charts page, your edited chart appears in the list.
Other features
You can view other chart actions by selecting the More menu icon (3 dots) at the upper-right corner of the chart.
For example, you can Pin the chart to your board, show underlying data, or download the chart to your device. When you select Download, you can choose your download type of PNG, XLSX, or CSV.