charts

Mar 15th, 2002, 07:47 AM

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 · Mar 15th, 2002, 08:02 AM

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. · Mar 15th, 2002, 10:54 AM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 07:47 AM	#1
Guest Posts: n/a	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?

Mar 15th, 2002, 08:02 AM	#2
DMeador52 New Member Join Date: Mar 2002 Posts: 32	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