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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hglamy - 25 Nov 2003 16:46 GMT

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

Reply to this Message

Jon Peltier - 25 Nov 2003 17:27 GMT

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
_______

> Hello there,
>
[quoted text clipped - 10 lines]
>
> H.G. Lamy

Reply to this Message

hglamy - 25 Nov 2003 17:44 GMT

Thank you, Jon !

Kind regards,

H.G. Lamy

> H.G. -
>
[quoted text clipped - 21 lines]
> >
> > H.G. Lamy

Reply to this Message

Rita Palazzi - 25 Nov 2003 17:47 GMT

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

Rita

> Hello there,
>
[quoted text clipped - 10 lines]
>
> H.G. Lamy

Reply to this Message

hglamy - 25 Nov 2003 17:56 GMT

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

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.
[quoted text clipped - 15 lines]
> >
> > H.G. Lamy

Reply to this Message