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-

Dynamic chart examples and links:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jay Somerset " wrote in message
...
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-

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

On Thu, 18 Jan 2007 19:56:12 -0500, "Jon Peltier"
wrote:

Dynamic chart examples and links:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jay Somerset " wrote in message
...
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-