Charts & Hidden Data

[Jay]

Hi,

If I hide the row/columns containing the source data of a chart the
respective series disappears from the chart.

Is there any way to hide chart source data without affecting the chart?

Many thanks,

Jason

 

[Bernard Liengme]

In XL2003 (and before) with chart selected: Tools | Options |Chart and
uncheck the box "Plot visible cells only"

In XL 2007: Follow this path: click the chart; use Chart
Tools|Design|Selected Data; look for button
labelled "Hidden and Empty Cells"; complete dialog box as needed.

best wishes

 

[Joe Clement]

Don't know if this will help, but it has worked for me on a couple of
occaisions. I had the "hidden" data in a small corner of the worksheet and
then parked the chart over the top of it. <g> Not very "elegant" but it
worked. As far as I know, nobody thought to look under the chart for the
data.