Dashboard Chart Data Selection

When I add a chart to a dashboard, it prompts me to select a sheet, but not the columns to display in the chart. If I try to select data fields of categorical labels and data that are not next to each other, I get an error. How do I select the data to display and can it be summarized? For example, I have a sheet tracking supplier assessments, which includes all of the measures, as well as an overall score, and I want to produce a chart of the average score by supplier and/or supplier score trend by date and/or factory. I would prefer to be able to select columns for display so that the range of values doesn't need to be updated as new assessments are added.

Find more posts tagged with

Sheets

Dashboards

Comments

Sasan

Janine,

Yes, in v1, the data range/table for a chart needs to be in a contiguous format (see image below). One suggestion is to summarize and place the data in a different sheet in a contiguous format, through cross-sheet formulas or cell links. Once you have a summary data table, then you can use that table for your chart. Thank you for your feedback on discrete range/column selection capability and we will consider your input in our future enhancements roadmap.

please see latest updated on charts in this discussion as well.

Thanks

Sasan

Janine,

We just released the new capability to select specific columns from your data range to chart against. After you have selected your data range, in the chart preview panel you will find a new button called "Select Columns". You can then select specific columns in your data range you want to chart against. Hope this help.

Sasan

rthorne

Sasan,

Is it possible to select specific rows from a data range? I'd like to chart the main tasks, but not their individual sub-tasks.

Thanks,

Richard

Sasan

rthorne,

At this time to chart specific rows there are two options:

1. Create a Report that will pull the data in the specific rows you desire for charting. Then in the chart creation flow, select the Report columns you want to chart against.

2. Create a separate sheet and use cell links or vlookup to bring the specific rows/values from your source sheet and stack under each other to create your data table needed for your chart.

Hope this helps.

Sasan

rthorne

Figured this might be the only way to go about it. Thank you.

Sasan

Pleasure.

mstanger

https://community.smartsheet.com/discussion/comment/69396#Comment_69396

Sasan, this selection capability isn't popping up for me. How do I find it?

I'm trying to create a column chart from a report, using the End Date on the X-axis. But it only selects the entire report as the data source and I can't find a way to choose the End Date for the axis.

Genevieve P.

Hi @mstanger

Are you using a Sheet, Report, or Grouped Report as the source of your chart? You should see the option to select what columns you want to use in the right hand panel where you Edit the Chart Widget:

Screen Shot 2021-11-09 at 4.56.52 PM.png

See: Using Chart Widgets and SmartStart: Dashboards

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Trending discussions

Project Dashboard
Is there an easy way to identify which cell or group of cells is being used for the information relaying from a sheet onto the dashboard?
Is it possible to create a Template and share it to other users?
Hi, I have the following dilemma- I have created a really good PMO system within smartsheets using different sheets & dashboards, I would love to roll this out to other users within my organisation to utilise it as a template My question is, is this possible and if so how do I do it? For context I am a consultant and we…
Smartsheet performance issues - current state
Hey there community. I'm conducting a bit of a straw poll of users to try and get to the bottom of whether the Smartsheet performance issues I'm seeing are down to me and my internet connection, or down to something Smartsheet's end. I've seen a significant increase in loading and refresh times over the past 3 months or…