charting hidden data?

  • Thread starter Thread starter mikelee101
  • Start date Start date
M

mikelee101

hello,
i just noticed that when i hide my datat table, my charts
go blank. is this normal? if so, is there any way to
chart hidden data?

thanks for the help.

mike
 
1. Select the chart
2. Choose Tools>Options, Chart tab
3. Remove the check mark from 'Plot visible cells only'
4. Click OK
 
thank you. i figured there must be a setting somewhere,
but i never would have found it.

thanks again.

mike
 
You must log in or register to reply here.

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

Inside Base Series Label Showing #N/A 0
Why won't data hide? 3
Display Hidden Columns in Charts 1
Charting Hidden Data 3
How to chart months by financial year 0
Chart data from hidden rows (not columns) 1
Charting blanks as spaces 1
JWalk Chart Tools and hidden row problem 1

Back
Top