Chart

[King_Nehale]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi, is there a way of hiding the chart source data without the chart itself being compromised?

Regards

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi, is there a way of hiding the chart source data without the chart itself
being compromised?

Regards

Sure, there are several ways. You can put the data (or the chart) on another
sheet. I often find it convenient to put the chart on top of the data. As
you noticed, if you hide rows or columns, the chart changes. This is by
design, and is a very handy feature.