Make a dynamic chart. The first link is a specific example that should help,
the second is an index to a bunch of examples:

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

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


"Jo" wrote in message
ups.com...
Hi everyone,

Say I have a table of x-y 5 rows. I plot them using xy option.

Now, say the # of the rows vary so sometimes I have 5 rows, another I
have 4 rows and so on. When I do the plotting for 5 rows, I get
straight line. Next, say now I have 4 rows, I have to go to each axis
and make a change to the cell number so the graph is right! If I have
3 rows, I have to re-do the cell # adjustment again!! If I don't do
so, the graph would be WRONG since it was designed for 5 points, now
for 4, and so on!

How can I automate that? I hope I did explain it clearly. If not,
please ask?

Thanks,
John