Charting Hidden Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi,

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

Cheers
Andy
 
Back
Top