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

  • Thread starter Thread starter hglamy
  • Start date Start date
H

hglamy

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
 
Thank you, Jon !

Kind regards,

H.G. Lamy


Jon Peltier said:
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
Click to expand...
 
May be cheating, but I'd set the column's color format to "none" instead of
actually hiding it. See if that helps.

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

Kind regards,

H.G. Lamy
 
Back
Top