If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Remove a column but not data table entry
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 |
#2
|
|||
|
|||
Remove a column but not data table entry
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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 |
#3
|
|||
|
|||
Remove a column but not data table entry
Thanks Luke, that was going to be my option in case deleting the column
wasn't possible. Thanks for confirming this for me. Claire "Luke M" wrote: 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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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 |
#4
|
|||
|
|||
Remove a column but not data table entry
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. "ClaireP" wrote: Thanks Luke, that was going to be my option in case deleting the column wasn't possible. Thanks for confirming this for me. Claire "Luke M" wrote: 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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|