Thanks Andy, I knew there had to be a way!!!
cheers
big t
"Andy Pope" wrote:
Hi,
Select the chart and then use menu Tools Options Chart. On the tab
uncheck Plot visible cells only.
Cheers
Andy
big t wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info