Charts - Dashboard Widget

I'm trying to create a pie chart using data from parent rows. I want to use first column as the labels and the corresponding (right) column with the numbers as the data. When trying to do so, I get the following message:

"Please select a cell or range of cells that are next to each other. If your rows are collapsed, please expand them before selecting"

But, I don't want to use the data in the expanded rows. I just want that data in the parent rows. How can I accomplish this?

Thank you!

Find more posts tagged with

Dashboards

Comments

Sasan

Max,

An alternative solution is to create another sheet and use cross-sheet formulas or cell links to reference the specific parent rows as labels and respective numbers, all within the range. Then a pie chart can be created against the new range. You can also create this new range with in the same sheet. If more than 3 series, make sure you click on Switch rows/columns to make a chart with more than 3 series.

Thanks

Sasan

mikehynes

Why can Smartsheet Labs Charts let you select whichever row you want and not this?

Sasan

Mike,

We acknowledge that Labs Charts lets you select which ever rows. We plan to provide solutions to enable users to select specific data as a range in future enhancements.

Thanks

Sasan

Sign in to join the conversation!

Quick Links

Trending discussions

Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…
Workspace is still there but all folders are empty
Hey, I had a Project in January where I created multiple sheets, dashboards etc. Now I want to prepare the same project again but all folders are empty. Not a single sheet is left. How is that possible ? I upgraded to a paid account during that time and Iwanted to do that again but smartsheet do not delete everything if…