Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Compare Data with a Chart

Communicate relationships within your data in real time with a chart.

PLANS

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Create a chart, for example, to demonstrate how your sales numbers are trending over time with a line chart sourced from data stored in Smartsheet.

Example of a pie chart displaying opportunities statuses percentages

 

Charts can be added to dashboards to quickly and easily communicate the health of a project, department, and more.

Before You Begin

Sharing requirements

To add a chart to a dashboard, you must be the Owner or have Admin-level sharing permissions to that dashboard. You must also be shared to the sheet or report that contains the data that you want to chart.

Data Format

The format of your data in the sheet is key to creating the right chart. Before you create a chart, make sure your data is:

  • On a single sheet or report. Currently, you can’t chart data from other dashboards, or automatically collect data from multiple sheets into a chart. If your data is in multiple sheets, you’ll want to either create cell links or use formulas to collect the data into a single sheet, or create a report to collect the data into one view.
  • Already summarized and collected. The Charts widget will plot your data as it appears in the sheet. You’ll need to create formulas beforehand if you want to perform calculations on the data.
  • Has labels on the top and left sides of the table. If you don’t have text labels on the top row of your data, the Charts widget will use your column names as labels instead. See Apply Custom Formatting to Your Chart for more information.

Note that only integers can be plotted. If your table contains non-integer values such as text or symbols, they will not be plotted.

 

Was this article helpful?
YesNo