How to have a chart automatically adjust range as I add data entr.
 

I have a spreadsheet linked to an access database. The spreadsheet refreshes
every 60 seconds automatically. I want to track current performance by using
a chart that shows the last 25 data points entered.
It is impractical to manually change the chart range each time a data entry
is added.
How can I make it change automatically to only include the last 25 entries?

How to have a chart automatically adjust range as I add dataentr.
 

Hi,

See Jon's explanation of the technique
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy

AdamCPTD wrote:
I have a spreadsheet linked to an access database. The spreadsheet refreshes
every 60 seconds automatically. I want to track current performance by using
a chart that shows the last 25 data points entered.
It is impractical to manually change the chart range each time a data entry
is added.
How can I make it change automatically to only include the last 25 entries?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info