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