Charting cells that have been grouped

[Guest]

When charting a large range of cells, which have been grouped in sets of 12
for convenience and easy review, the chart using this data is blank. If I
ungroup the cells, the chart shows the data.

Is there a way around this? Why can't a chart show the data even if the
data is hidden?

 

[Jon Peltier]

I don't know what you mean by "grouped" cells. Are you hiding cells? By
default Excel doesn't display hidden data on a chart.

To change this behavior: Select the chart, go to Tools menu > Options >
Chart, and uncheck Plot Visible Cells Only.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______