Why the hidden column can't be shown on charts?
 

It is strange that when the data is quoted from a hidden column, the data
can'be showed on charts. is it one default excel charts properties?

I'm not farmilia with excel chart. does anyone can help me let this data
shown on charts?

Thanks and regards,
Viesta

Why the hidden column can't be shown on charts?
 

Hi,

It is an option. in xl2003 select the chart and then use the menus
Tools Options Chart
uncheck Plot visible cells only

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ViestaWu" wrote in message
...
It is strange that when the data is quoted from a hidden column, the data
can'be showed on charts. is it one default excel charts properties?

I'm not farmilia with excel chart. does anyone can help me let this data
shown on charts?

Thanks and regards,
Viesta