hidden data in a graph

[Carrie]

I need to graph hidden data. I need to only show cirtain columns but the other columns need to be hidden.

When I hide the data the bars disappear from my graph. I searched and know about the format...cells...custom...;;; but this just makes the data disappear.

I need to HIDE the columns.

Please Help.

 

[plettieri]

Hi:

You might consider a custom view that "ghosts" the text in the data you wish to hide.

That is, match the color of the text to that of the color of the cell....thus it seems to be hidden...then save this view as a custom view for later recall


hope this helps

plettieri

 

[Andrew Poulsom]

Activate the chart, choose Tool|Options|Chart tab and uncheck "Plot visible cells only".

 

[Carrie]

Thank you, Thank you, Thank you!

The Tools Options thing is exactly what I needed.

 

[bab01824]

Any solution updates for Excel 2010?

 

[Asala42]

In 2010 they stealthed the option here:

Select the Chart -> Design Tab -> "Select Data" -> "Hidden and Empty Cells" -> Check off "Show data in hidden rows and columns".

Repeat for each chart.