Hello.

I'm using Excel 2007.

I have a chart based off of a series of values. When I hide those values
the chart disappears. I don't want that.

I know in 2003 there was an option to allow you to plot hidden cells but I
can't find it in 2007.

Does anyone know where that option is?

Thanks.
--
Jeff