Reference: Chart Types

You can choose from a variety of chart types to visualize your data stories.

Area

An area chart
visualizes trends as data points, where the x-axis is time or dimension. This chart is similar to a line chart with color fills between the line and the threshold.

See Reference: Area and Line Chart Settings.

Bar

A bar chart
visualizes multi- data series as horizontal columns, where the y-axis is time or dimension. This chart is similar to a column chart where the axes are switched.

See Reference: Bar and Column Chart Settings and Create a Bar Chart Focused on Sales by Regions.

Column

A column chart
visualizes a data series as vertical columns, where the x-axis is time or a dimension.

See:

Reference: Bar and Column Chart Settings.

Example: Create Multiseries Column Charts for Product and Service Revenue.

Crosstab

A crosstab
visualizes data in tabular format. This chart is often used to compare relationships between data sets.

See Crosstab Charts, Create a Crosstab Chart, Reference: Crosstab Chart Settings.

Dimension Mapping

A dimension mapping
table lets you dynamically group data based on user-defined multi-dimensional lookup rules. Dimension values in modeled sheet rows are returned based on your rules.

Doughnut

A doughnut
visualizes a data series as a circular chart. This chart is similar to a pie chart without the center.

See Reference: Doughnut and Pie Chart Settings.

Fan

A fan
chart visualizes variances for forecast versions compared to a reference version.

See Reference: Fan Chart Settings.

Gauge

A gauge
visualizes data as a meter (speedometer) or gauge. Often used to represent percentages, such as a gross margin percentage or EBITDA percentage. Zones indicate if the metric is good, fair, or bad.

See Reference: Gauge and Meter Chart Settings.

Geo Map

A geo map
visualizes accounts with geographic data. Compare and contrast values across different regions with circle size and color.

See Create Geo Maps.

KPI

A KPI
(key performance indicator) visualizes a metric in way that helps you understand how your business is doing relative to set goals.

See:

Reference: KPI Chart Settings.

Example: Create KPIs for Variance Between Planned Product Revenue and Actuals.

Line

A line chart
visualizes trends as data points, where the x-axis is time or dimension.

See Create a Period-over-period Chart and Reference: Area and Line Chart Settings.

Pie

A pie
visualizes a data series as a circular chart with slices sized proportionally to represent the data values.

See Reference: Doughnut and Pie Chart Settings.

Scatter

A scatter chart
visualizes trends as data points, where the x-axis is time or dimension.

See Create a Scatter Chart and Reference: Scatter Chart Settings.

Scorecard

A scorecard
visualizes a series of data in a tabular format that summarizes actuals versus planned data, and variance. This chart often includes a micro chart to highlight key metrics.

See Add a Scorecard to a Dashboard and Reference: Scorecard Settings.

Sheet

Use sheets on dashboards to enter data without navigating away from your dashboard. Save your sheet to dynamically see changes on dependent charts and dashboards.

See Add Sheets on Dashboards and Reference: Sheets on Dashboards Settings.

Text

A text
in a dashboard can provide guided assistance, usage notes, or general information or notes about visualizations displayed on the dashboard.

See Add Text to Dashboards.

Waterfall

A waterfall
visualizes data to show where you started, where you ended, and how you got there. The initial and the final values are often represented by whole columns, while the intermediate values are denoted by floating columns.

Example: A finance department can use variance analysis to compare the revenue plan with revenue actuals and to show the positive and negative variance across a GL revenue sub-account or across different geographic regions.

See Create a Waterfall Variance Chart and Reference: Waterfall Chart Settings.