Thread: Remove a column but not data table entry
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta Tushar Mehta is offline
external usenet poster
  
Posts: 126
Default Remove a column but not data table entry
You may also want to create your own data table.
Custom Chart Table
http://www.tushar-mehta.com/excel/ne...able/index.htm


On Thu, 8 Oct 2009 02:37:01 -0700, ClaireP
wrote:

Hi there,

I have a column chart in Excel with 5 columns plotted and a data table below
to show the values. I would like to remove 2 of the columns from the graph
but NOT from the data table itself.

Is this possible? When clicking delete on the columns in the graph, it
removes the entry in the data table too.

Thanks
Claire
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
Reply With QuoteReply With Quote