Hidden Data to show on the Chart

[Brisvegaslad]

Hi all,

I have a spreadsheet with one TAB holding all my data, and a second TA
holding my Chart. The spreadsheet grows and grows by the column, th
rows are pretty much fixed. Since the spreadsheet gows horizontally,
hide a lot of the earlier columns for ease of maintenace. I hav
created line charts for a couple of rows. My problem is, I want th
chart to chart on all the data, including the hidden data, however whe
I hide say 20 columns, those columns are no longer represented on th
chart - unhide them and they reappear on the chart. Is there any way o
ensuring the chart uses the data specified regardless of wether the dat
is hidden or not.

Thanks in advance

 

[Andy Pope]

Hi,

Select the chart and then via the menus Tools > Options go to the Chart
tab. Here is an option to plot visible cells only, which you can unselect.

Cheers
Andy

 

[Brisvegaslad]

Thanks very much Andy, issue solved.