charts

[Guest]

I have a chart pulling data from columns that I want hidden. When I hide them, the chart goes blank. Is there any way to keep this from happening?

 

[DMeador52]

I've found the simplest thing to do is to change the text color on the cells to be the same as the background. The column is still there, but the data is invisible.

Doug

 

[Mark W.]

On 2002-03-15 06:47, Anonymous wrote:
I have a chart pulling data from columns that I want hidden. When I hide them, the chart goes blank. Is there any way to keep this from happening?

Put your data on a separate worksheet and hide that worksheet using the Format | Sheet | Hide menu command.