Charting Hidden Data

[Guest]

Hi Everyone,

I am charting data which sits in rows where i have grouped the data (using
Data...Group and Outline...Group...). Trouble is, when I hide the data (by
collapsing the grouped rows) my chart goes blank.

Is there a way to allow charts to see the 'hidden' data?

TIA,
big t

 

[Don Guillett]

AFAIK, No, but you could copy somewhere else and chart that

 

[Andy Pope]

Hi,

Select the chart and then use menu Tools > Options > Chart. On the tab
uncheck Plot visible cells only.

Cheers
Andy

 

[Guest]

Thanks Andy, I knew there had to be a way!!!

cheers
big t