Click chart
Click the Design tab on the Ribbon
Go to the Data group; click Select Data
In the dialog box, click the button in lower left corner "Hidden and Empty
Cells"
In the next dialog box, click the box "Show data in hidden rows and columns"
OK out of this
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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