How to use a dynamic range with OFFSET to create a chart in separate workbook

Hi All,

I have 2 example workbooks attached.

Workbook ChartOffset contains data and I want to to use it to create a chart in Workbook Charts without having to manually copy & paste all data into Workbook Charts from Workbook ChartOffset.

In Workbook Charts sheet NewChart I have set up the dynamic ranges from Workbook ChartsOffset but cant work out how to draw chart in Workbooks Charts.

Workbok ChartOffset is continually added to & I would like only the last 150 entries ever to be be charted.

I would like o create a chart the same as in Workbook Charts-Worksheet AGA! without having to duplicate all the data on two workbooks.

Many Thx Jojo