Learning Track
This Help Article appears in the Level 3: Advanced Users learning track. Get the most out of this learning track by starting at the beginning.
This Help Article appears in the Level 3: Advanced Users learning track. Get the most out of this learning track by starting at the beginning.
Live charts are stored as widgets on Smartsheet dashboards. (See our help article on dashboards for more information on this feature.)
TIP: If you need to change your data range later, edit the widget and click Edit Data to reselect the data range.
Once you’ve selected your data,select a chart type and formatting.
Now that you’ve chosen the data you want to chart,you can select a chart to visually represent your data. Smartsheet automatically suggests a chart type based on how the data in your range is formatted. You can select a different chart type on the right side of the Edit Chart Widget form.
Data that you want to compare |
Recommended chart |
---|---|
How numbers have changed over time |
line, smooth line, stepped line |
Directly compare numbers against each other |
column, bar, stacked column, stacked bar |
Show how individual numbers relate to the whole of your data set |
Pie, donut |
Smartsheet offers the following chart types:
The chart widget supports charting only for the following column types:
Learn more about different column types in Smartsheet in Use the Best Column Type for Your Data.