rolling data

  • Thread starter Thread starter amyh
  • Start date Start date
A

amyh

I have a spreadsheet which requires people to add another piece of data
every day. It is plotted into a chart. What I want is for the chart to
use only the last 20 columns or so for the chart. How can I do this?
(I am not familiar with Macros, but could pick it up if needed.)

thanks.
 
I think the dynamic charting link you gave me will help. The next step
to the puzzle will be how to drop off the old data. As I add a new
piece of data, I need to drop off the oldest piece. Any idea how to
accomplish this?
 
The 'Another Dynamic Chart ??' contains the options to change the start
point.
It is just a case of amending the first part of the OFFSET() formula.

I think the dynamic charting link you gave me will help. The next step
to the puzzle will be how to drop off the old data. As I add a new
piece of data, I need to drop off the oldest piece. Any idea how to
accomplish this?
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top