Automatically changing the range in a graph
 

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?

Automatically changing the range in a graph
 

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