Thanks. I am using dynamic range names, but I think I figured out my problem
(see above posts).

I do have another question however. On a line graph, is there a way to show
a break in the values on the y-axis (have them jump from say 60 to 1000)? I
have multiple lines graphed on the same chart, but their values are so
different that the bottom line gets lost (and I don't have a lot of space to
blow up the graph to see it).

"ShaneDevenshire" wrote:

Hi,

1. Assuming the data is vertical, when you add new data you are adding below
the previous data, and assuming you are using 2003 or 2007. Select the data
area and press Ctrl+L this opens the create table or create list dialog box.
Now as new data is added (or old data rows deleted) the chart will adjust
automatically.
2. Assume you are not using 2003 or 2007 or that your data increases to the
right. This you will need dynamic range names.

If you need this send me a request and I will send you a file showing how to
do it.

--
Cheers,
Shane Devenshire


"kal4000" wrote:

Is it possible to create a dynamic area chart - an area chart which updates
its values when new data is entered? I can't seem to make it work.