View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Charting cells that have been grouped

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" wrote in message
...
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?