Automatically changing the range in a graph

[Bret Davis]

I constantly add data to a spreadsheet and I want to only graph the last 24
data points with out constantly cahnging the graph range. How do I do this?

[Debra Dalgleish]

Jon Peltier has instructions for a dynamic chart:

http://www.peltiertech.com/Excel/Cha...tml#DynoLast12

Bret Davis wrote:
> I constantly add data to a spreadsheet and I want to only graph the last 24
> data points with out constantly cahnging the graph range. How do I do this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html