Sheet Summary Report Chart

Ross Novotny
Ross Novotny ✭✭✭✭✭
edited 03/21/23 in Formulas and Functions

I continue to get an error when I try to create a chart of a Sheet Summary Report. The error states "Selected Data can not be charted. Please select a new range". The data is pretty straightforward, its a list of 15 locations with a completeness between 0 and 100. I tried removing the percentage in my sheet summary formula, but the result is the same. Does anyone know why I wouldn't be able to chart the data in a bar graph (or any graph)?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!