charting hidden data?

[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

 

[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

 

[mikelee101]

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

thanks again.

mike