Create a Chart for a Dashboard

Live charts are stored as widgets on Smartsheet dashboards. (See ourhelp article on dashboardsfor more information on this feature.)

To create a chart widget:

1. On the right rail, click the+button. Or selectChartfrom theAdd Widgetdropdown in the编辑menu.
2. From the Add Widget box, selectChart.
   
   
3. Before you can select your chart, you must first select your data. ClickAdd Datain theData & Chart Typesection.

4. On the left side of the form, select the sheet or report that contains the table you want to chart. Then select the range of cells on the right side.
5. Once you have your data selected, clickOK.

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.

Select Your Chart Type

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编辑Chart Widgetform.

• If the data doesn’t look as expected, clickSwitch rows/columns.
• Pie and donut charts do not display zero values

Available Chart and Column Types

Chart Types

Smartsheet offers the following chart types:

• Line
• Smooth line
• Stepped line
• Bar
• Stacked bar
• Column
• Stacked column
• Pie
• Donut
• Scatter

列类型

The chart widget supports charting only for the following column types:

• Text/Number: Values must be numbers only
• Dropdown List:Numbers only, excluding text strings that look like numbers
• Auto-Number/System-generated column:Numbers with no Prefix or Suffix (no text)
• Symbols:Numbers only (symbols can't be charted)

Learn more about different column types in Smartsheet inUse the Best Column Type for Your Data.