Want to Hide columns in spreadsheet but NOT hide data in chart.

's Computer Specifications

Is there a way to do this? Maybe unbound/unlink the data source so the chart
does not change when i change the spreadsheet?

's Computer Specifications

Hi,

You need to disable the Plot visible cells only.

xl2003 - Select chart then Tools > Options > Chart > Plot visible cells
only.

xl2007 - select chart then Chart Tools > Design > Select Data > Hidden and
Empty cells > Plot visible cells only

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"KrispyData" <(E-Mail Removed)> wrote in message
news:7161FB5D-30E2-4851-833C-(E-Mail Removed)...
> Is there a way to do this? Maybe unbound/unlink the data source so the
> chart
> does not change when i change the spreadsheet?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
want to print -pop-up says "save"..dont want it-I want to print	=?Utf-8?B?Y29tcHV0ZXJsb2dpYw==?=	Microsoft Outlook Discussion	1	4th Feb 2007 01:03 AM
Copy and pasting on columns but on spreadsheet with alot of data	=?Utf-8?B?TWljaGFlbA==?=	Microsoft Excel Misc	2	10th Oct 2006 01:49 PM
In Excel I want to copy text from spreadsheet to spreadsheet	=?Utf-8?B?S3Jpcw==?=	Microsoft Excel Worksheet Functions	3	9th Jun 2006 07:58 PM
Program link to Excel spreadsheet opens Excel but not spreadsheet	=?Utf-8?B?Y2I=?=	Microsoft Excel Crashes	1	11th Feb 2006 03:55 PM
Re: I want todays date in my spreadsheet to be red. I also want this.		Microsoft Excel New Users	0	14th Apr 2005 03:04 PM