You can fake it:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

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


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