Resizing the source data table

[johnturgoose]

This may be something stupid but anyway...

I have a table that is growing every month.

I want to produce a chart that automatically grows as the table grows.

I have used the OFFSET function to define a dynamic range. When I enter the name into the chart 'DATA RANGE' all is well. However on returning to it the Range name has been replaced by the cell reference. Obviously the table is no longer sensitive to any additional data I add into my source data table.

I have also tried entering the OFFSET function directly into the DATA Range field. Again this works as above.

Any ideas gratefully accepted

Thanks in Advance

John

 

[SkipVought]

John,

Name each SERIES -- NOT the data range using the OFFSET Function.

Make sure that you use the named ranges INCLUDING the Sheet reference -- ie for a range named MyDates on Sheet2...
[tt]
=Sheet2!MyDates
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244