Friends
I want to produce a simple line chart. The data I want on this chart is
located in the same cell range but on a number of worksheets. Example sheet1
A 17, sheet 2 A17 sheet 3 A17 ect. How do I add this data to form one chart?
I am looking to see a moving scale of the data in A17.
My aim is to keep adding new data to a new work sheet in the same work book
and have this constant A17 updating my chart.