Remove a column but not data table entry


C

ClaireP

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
 
Ad

Advertisements

L

Luke M

Instead of deleting the column, you could try formatting the column to have
no fill and no border. It will still take up phsyical space (but since you're
using a data table, this might be preferred to avoid mis-alignement), but it
won't be visible.
 
C

ClaireP

Thanks Luke, that was going to be my option in case deleting the column
wasn't possible. Thanks for confirming this for me.
Claire
 
T

trip_to_tokyo

In EXCEL 2007 hiding the columns (right click a column and select Hide) will
remove the data from the graph without removing the data from the Workbook.

Please hit Yes if my comments have helped.

Thanks.
 
Ad

Advertisements

T

Tushar Mehta

You may also want to create your own data table.
Custom Chart Table
http://www.tushar-mehta.com/excel/newsgroups/data_table/index.htm


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top