Sheet Summary Report Chart
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)?
Help Article Resources
Check out the Formula Handbook template!