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?

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/
_______

"Fuller" <(E-Mail Removed)> wrote in message
news:C38C378F-CE3F-402C-B9FC-(E-Mail Removed)...
> 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?