Charts & Hidden Data

J

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
 
J

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.
 
Top