Keep getting "Selected data cannot be charted please select new range" error.

betcha663

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.

Paul Newcome

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.

betcha663

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

Sheet Summary Reports | Smartsheet Learning Center

Paul Newcome

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.

betcha663

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.

Mike Tomei

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

betcha663

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.

betcha663

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

Sheet Summary Reports | Smartsheet Learning Center

Cathy D

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