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

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying embedded charts 1
Inside Base Series Label Showing #N/A 0
Display Hidden Columns in Charts 1
washed out charts 3
Charts with data from MS Query 1
Clustered-Stacked-Column Combo Chart With Lines 2
How to create multiple bar charts at the same time? 0
Copy Charts/formulas will not adjust? 0

Top