To learn more about Smartsheet Regions, click here.

Applies to

Smartsheet

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 When adding a title, make sure the Show Title toggle is turned on. To change the format of a title, use the formatting buttons to make changes to that title
Add a title to your axes	Expand the Horizontal Axis or Vertical Axis sections, as needed Enter your title To change the format of a title, use the formatting buttons to make changes to that title
Add or move a legend on your chart	Expand the Legend section and select one of the following options: No Legend Top Right Bottom Left 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: Hide Percentage (%) Amount
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: Take no action Open the data source Open another site... Open a Smartsheet item...
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.

Was this article helpful?