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

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

Guest

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
 
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
 
Back
Top