Chart disappears when values are hidden

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
Perfect. Thank you.
--
Jeff


Bernard Liengme said:
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
Click to expand...
 
Back
Top