Learn how to modify your Smartsheet charts. Customize chart types, titles, axes, series data, legends, and widget behavior.
USM Content
You can add a chart based on a table of data from a sheet.
Learn more about how to create a chart widget for your dashboard in Compare data with a chart.
If you base your chart on report data, configure the widget to show the data the way you want—either from the perspective of the last widget: Editor or Viewer. See Control widget content when its source is a report for more information. Also, when you use a report as the source for a chart widget, report data selection happens automatically.
| To do this | Follow these steps |
|---|---|
| Switch how columns and rows are plotted on your chart. | Toggle on/off Switch rows/columns. |
| Change the chart type. | Select the chart type you want to use from the drop-down menu. |
| Add a title to your chart. | Expand the Title section and enter your title as needed. Toggle on/off Show Title as wanted. Use the styling options to format the title. |
| Add a title to the horizontal/vertical axis of your chart. | Expand the Horizontal or Vertical Axis section and enter your title as needed. Use the styling options to format the title and label. Toggle on/off to Show tick marks. |
| Edit series data. | Select which series to edit. Toggle on/off to show the value label. Toggle on/off to fill lines. |
| Add or move a legend on your chart. | Expand the legend section and select the option you want to use. Use the styling options to format the legend. |
| Add gridlines to your chart (except pie charts). | Expand the Horizontal Axis or Vertical Axis sections and toggle on show gridlines. |
| Label slices of a pie chart with a percentage of the whole or actual values | Expand the Pie Chart & Series section. Select the Value Labels drop-down menu and select the option you want to use. Here, you can change the colors for each section of the pie chart and toggle on/off the option to display it as a semicircle. |
| Change the colors of the data or add labels to the data plotted in your chart. | Expand the Series section and choose which item to apply formatting to. Note that the default option applies to all data in the chart. |
| Ignore the text labels that you’ve typed in the cells of your table. | Toggle on Use column names as category labels. |
| Edit the interaction of the widget (interaction is what happens when you select the widget). | Expand the Widget behavior section. You can choose the action you wish to happen when selecting the widget. |
Make your changes and select Done.
Frequently Asked Questions
I want to use the data in the top row of my table as labels, but the chart is using my column names instead. How do I fix this?
When integer values are in the top row of your data, the charts widget assumes these values are meant to be plotted and uses the column names as labels instead. To force the use of the data in the top row of your table as labels, uncheck Use column names as category labels.
Can a chart be created from data in more than one sheet?
Currently, charts can only be created against data in a single sheet or report. If your source data is on multiple sheets, create a report to collect the information, or use cell links or a formula that references data from another sheet to collect your data into one sheet. More information on these options can be found in the following help center articles:
My custom color configuration doesn’t display on an existing chart. How do I save a custom color configuration to a series in a chart?
When a chart uses a row-based grouping and summary report, and only one column is selected under Columns Included in the chart widget editor, you can't save a custom color configuration for the charted series.
If you change the series colors from the default, the system reverts them to the default colors when you save.
To fix this:
- Edit the chart widget. For more information on how to edit a chart, see Customize the format of your chart.
- Under Columns Included, select the primary column to name the series.
- Select Series, then select each value to update color choices. Once you save, the custom color configuration displays on the chart and persists.
My chart labels disappear. What should I do?
Smartsheet occasionally hides labels to highlight the chart and improve legibility. To showcase the label, either lower the font size or resize the widget.