Display Hidden Columns in Charts
 

In Excel 2003 is it possible to display hidden columns (or rows) in a chart.
When I hide columns for my charts the default is to remove the hidden data
from the chart.

Display Hidden Columns in Charts
 

Tools menu Options Chart, uncheck Plot Visible Cells Only.

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


"Dave" wrote in message
...
In Excel 2003 is it possible to display hidden columns (or rows) in a
chart.
When I hide columns for my charts the default is to remove the hidden data
from the chart.