Hi,

Select the chart and from the context tab click
Design Data group Select Data
On the select data source dialog is a button, Hidden and empty cells.
On this dialog box is the Show data in hidden rows and columns.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jeff Reese" wrote in message
...
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