Keep getting "Selected data cannot be charted please select new range" error.
My first time creating a dashboard and getting error "Selected data cannot be charted please select new range" trying to add data from a RAID sheet. After clicking Add Data, I select the file and click on columns to include in the chart but nothing happens. After clicking OK I see the error message "Selected data cannot be charted please select new range" I am using Microsoft Edge browser.
Best Answers
-
Charts require at least one column with numeric data. Depending on what you are wanting to display on the chart and how you may need to either create a report with grouping/summary options filled in or create a separate metrics sheet that contains the counts/labels in a table.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
UPDATE:
I did some research and found the following which helped:
SHEET SUMMARY REPORT - "columns to display" not showing up — Smartsheet Community
This video shows how to create the summary report. Only difference was when creating a new report I selected ''Row report" instead of "Show summary report" and my columns appeared
Answers
-
Charts require at least one column with numeric data. Depending on what you are wanting to display on the chart and how you may need to either create a report with grouping/summary options filled in or create a separate metrics sheet that contains the counts/labels in a table.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you for your response.
What I'm trying to do is get an total number of items actions, risks and issues as well as total number of items, items in process, completed etc. Kind of what a pivot table displays in Excel. It is those numbers that I would like to be charted.
If these numbers are not calculated the same way a pivot table is calculated on the fly in Excel, how can the same concept be achieved from an active smartsheet? Is there an example somewhere that shows the steps in how to do? Again, this is my first attempt at dashboards, any help is appreciated.
Thanks again.
-
Create a summary sheet that does these counts/sums for you, then create your dashboard charts from that summary sheet? Like what's being done by the Portfolio Metrics sheet within the PMO template: Project Management Office Template Set | Smartsheet
-
Thanks Mike.
Wow. The example you provided looks awesome and I will definitely look thru it!
Is there a simpler example that I can access for now? Perhaps one that shows a smartsheet and how a summary sheet is created from that smartsheet? Thanks again.
-
UPDATE:
I did some research and found the following which helped:
SHEET SUMMARY REPORT - "columns to display" not showing up — Smartsheet Community
This video shows how to create the summary report. Only difference was when creating a new report I selected ''Row report" instead of "Show summary report" and my columns appeared
-
I am having this problem as well. I've selected only cells with numerical data from a sheet:
The screenshot shows an example of the formula.
Any ideas?
C
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives