RE: Remove a column but not data table entry

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • RE: Combo Bar-Line Graph with single list of data
    ... Check out Jon Peltier's article: ... Luke M ... "Melody" wrote: ... I'm trying to create a combination graph where my data for 2008 and 2009 ...
    (microsoft.public.excel.misc)
  • RE: How to Remove text values from graphs
    ... Could you setup a hidden table somewhere that duplicates your original data ... And then create your graph from this hidden table? ... "Luke M" wrote: ...
    (microsoft.public.excel.misc)
  • Re: ATWT - Thursday questions
    ... He's confirming Luke's worst fears ... Luke was out of control with anger when Lily had her accident. ... FAC Hannah Lafferty ...
    (rec.arts.tv.soaps.cbs)
  • Re: syntax to concatenate two named ranges?
    ... Awesome, thanks Luke! ... I'm not trying to graph these as separate series, I want it to all be one ... In my real workbook these are dynamic ranges, ...
    (microsoft.public.excel.misc)
  • RE: How to Remove text values from graphs
    ... come up in order for my workbook to meet other criteria... ... "Luke M" wrote: ... I only want the graph to graph ...
    (microsoft.public.excel.misc)