charting hidden data?

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
 
D

Debra Dalgleish

1. Select the chart
2. Choose Tools>Options, Chart tab
3. Remove the check mark from 'Plot visible cells only'
4. Click OK
 
M

mikelee101

thank you. i figured there must be a setting somewhere,
but i never would have found it.

thanks again.

mike
 
Top