Applies to
- Pro
- Business
- Enterprise
Capabilities
Who can use this capability
- Owner
- Admin
Customize the format of your chart
You can change the formatting options on a chart, including fonts for titles and legends, chart type, and more.
Who can use this?
Plans:
- Smartsheet
- Pro
- Business
- Enterprise
Permissions:
- Owner
- Admin
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Edit a chart
- Select the pencil (Edit) icon in the top right corner of the dashboard or select Edit > Edit Dashboard...
- Hover over the chart widget, select the three-dot (More) menu icon > Edit.
Formatting options
| To do this | Follow these steps |
|---|---|
| Chart only certain columns from the selected range | Select Columns Included and select only the columns you want to display. |
| Switch how columns and rows for a different view of the data | Select Switch rows/columns |
| Change the chart type | Use the dropdown to select the chart type you want to use |
| Add a title to your chart | Expand the Title section and enter your title
|
| Add a title to your axes | Expand the Horizontal Axis or Vertical Axis sections, as needed
|
| Add or move a legend on your chart | Expand the Legend section and select one of the following options:
Use the formatting buttons to make changes to the legend. |
| Add gridlines to your chart (except pie charts) | Expand the Horizontal Axis or Vertical Axis sections and enable the Show tick mark lines toggle |
| Labels slices of a pie or donut chart with percentage of the whole or actual values | Expand the Pie Chart or Donut Chart section, and use the dropdown under Value Labels to select one of the following:
|
| Change the colors of data or add labels to data plotted in your chart | Expand the Series section and choose which item to apply formatting to. By default, white text appears on dark background, black text appears on light backgrounds. |
| Ignore the text labels that you’ve typed in the cells of your table | Check the box for Use column names as category labels under the Data & Chart Type section. |
| Edit the interaction of the widget (interaction is what happens when you click the widget) | Select Widget Behavior and choose one of the interaction options:
|
| Pie and Donut charts: display as a half-pie or half-donut | Expand the Pie Chart & Series section and enable the Display as semicircle toggle. |