Thread: Want to Hide columns in spreadsheet but NOT hide data in chart.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Want to Hide columns in spreadsheet but NOT hide data in chart.
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" wrote in message
...
Is there a way to do this? Maybe unbound/unlink the data source so the
chart
does not change when i change the spreadsheet?

Reply With QuoteReply With Quote