Hi all,

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

Thanks in advance.