rolling data

[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.

 

[Andy Pope]

Hi amyh,

Take a look at Jon's examples of dynamic charts,
(http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html#DynColCht)

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.

--

Cheers
Andy

http://www.andypope.info

 

[briank]

I use the offset function to generate only the latest set
of data entered into a chart.

 

[amyh]

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?

 

[Andy Pope]

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?

--

Cheers
Andy

http://www.andypope.info

 

[amyh]

Thanks Andy! I will give it a try!