How keep chart-datapoints displayed when column-width is set to zero

Hello there,

my data basis for a chart has one column,
that I don't want to be shown in the spreadsheet.

However, when I set this column's width to zero,
the correspondig data dissapear from the chart.

How can I have both, a hidden column and its
values shown in the chart at the same time ?

Kind regards,

H.G. Lamy

H.G. -

Select the chart, then select Options from the Tools menu, click on the
Chart tab, and UNcheck the Plot Visible Cells Only checkbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

hglamy wrote:

> Hello there,
>
> my data basis for a chart has one column,
> that I don't want to be shown in the spreadsheet.
>
> However, when I set this column's width to zero,
> the correspondig data dissapear from the chart.
>
> How can I have both, a hidden column and its
> values shown in the chart at the same time ?
>
> Kind regards,
>
> H.G. Lamy
>
>

Thank you, Jon !

Kind regards,

H.G. Lamy


"Jon Peltier" <jonpeltierNOSPAM@yahoo.com> schrieb im Newsbeitrag
news:#97JSl3sDHA.560@TK2MSFTNGP11.phx.gbl...
> H.G. -
>
> Select the chart, then select Options from the Tools menu, click on the
> Chart tab, and UNcheck the Plot Visible Cells Only checkbox.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> http://www.geocities.com/jonpeltier/Excel/index.html
> _______
>
> hglamy wrote:
>
> > Hello there,
> >
> > my data basis for a chart has one column,
> > that I don't want to be shown in the spreadsheet.
> >
> > However, when I set this column's width to zero,
> > the correspondig data dissapear from the chart.
> >
> > How can I have both, a hidden column and its
> > values shown in the chart at the same time ?
> >
> > Kind regards,
> >
> > H.G. Lamy
> >
> >
>

May be cheating, but I'd set the column's color format to "none" instead of
actually hiding it. See if that helps.

Rita

hglamy wrote:
> Hello there,
>
> my data basis for a chart has one column,
> that I don't want to be shown in the spreadsheet.
>
> However, when I set this column's width to zero,
> the correspondig data dissapear from the chart.
>
> How can I have both, a hidden column and its
> values shown in the chart at the same time ?
>
> Kind regards,
>
> H.G. Lamy
>
>

You're right, that would do it as well, thank you !
However, this way data may accidentally be overwritten.

Kind regards,

H.G. Lamy

"Rita Palazzi" <rmpalazzi@fedex.com> schrieb im Newsbeitrag
news:3FC395A5.1010702@fedex.com...
> May be cheating, but I'd set the column's color format to "none" instead
of
> actually hiding it. See if that helps.
>
> Rita
>
> hglamy wrote:
> > Hello there,
> >
> > my data basis for a chart has one column,
> > that I don't want to be shown in the spreadsheet.
> >
> > However, when I set this column's width to zero,
> > the correspondig data dissapear from the chart.
> >
> > How can I have both, a hidden column and its
> > values shown in the chart at the same time ?
> >
> > Kind regards,
> >
> > H.G. Lamy
> >
> >
>