charting hidden data?

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

mikelee101 wrote:
> 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?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

thanks again.

mike

>-----Original Message-----
>1. Select the chart
>2. Choose Tools>Options, Chart tab
>3. Remove the check mark from 'Plot visible cells only'
>4. Click OK
>
>mikelee101 wrote:
>> 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?
>
>--
>Debra Dalgleish
>Excel FAQ, Tips & Book List
>http://www.contextures.com/tiptech.html
>
>.
>