software

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 quot;groupedquot; 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 gt; Options gt;
Chart, and uncheck Plot Visible Cells Only.

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

quot;Fullerquot; gt; wrote in message
...
gt; When charting a large range of cells, which have been grouped in sets of
gt; 12
gt; for convenience and easy review, the chart using this data is blank. If I
gt; ungroup the cells, the chart shows the data.
gt;
gt; Is there a way around this? Why can't a chart show the data even if the
gt; data is hidden?