Displaying hidden data on a chart
 

I have a number of data series in a table on sheet 1, and this data is
plotted as an x-y scatter in a chart on sheet 2. I want to hide a column in
the table, but when i do this the related data series disappears from the
chart. Is there a way to hide a column whilst still having it plotted on the
chart? At the moment I have just set the column width to 1 pixel, which is a
bit messy.

Thanks

Displaying hidden data on a chart
 

Hi,

Yes, select the chart and then via the menu Toosl Options Chart.
unchecked the Plot visible cells only.

Cheers
Andy

Nick Terry wrote:
I have a number of data series in a table on sheet 1, and this data is
plotted as an x-y scatter in a chart on sheet 2. I want to hide a column in
the table, but when i do this the related data series disappears from the
chart. Is there a way to hide a column whilst still having it plotted on the
chart? At the moment I have just set the column width to 1 pixel, which is a
bit messy.

Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Displaying hidden data on a chart
 

Thanks Andy, problem solved!

Cheers






"Andy Pope" wrote:

Hi,

Yes, select the chart and then via the menu Toosl Options Chart.
unchecked the Plot visible cells only.

Cheers
Andy

Nick Terry wrote:
I have a number of data series in a table on sheet 1, and this data is
plotted as an x-y scatter in a chart on sheet 2. I want to hide a column in
the table, but when i do this the related data series disappears from the
chart. Is there a way to hide a column whilst still having it plotted on the
chart? At the moment I have just set the column width to 1 pixel, which is a
bit messy.

Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info