How to make a Chart with a Variable Data Window

[Jay Somerset]

I've been going nuts trying to figure out how to chart the last N rows of
data entered in to table, without programming it in VB. I'm sure there is a
simple way to do this with worksheet functions, but for the life of me I
just can't see it.

Example:
Date & Value data, in columns A and B, with each day's data entered in the
next unused row. I want to plot only the last 10 entries, for example, so
that I have a running chart containing only the 10 most recent entries.

Can someone please point out the obvious to me?

Thanks.
-Jay-

 

[Jon Peltier]

Dynamic chart examples and links:

http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon

 

[Jay Somerset]

Many thanks. That is just what I was looking for.
-Jay-