Alan -

Thanks for following up. Makes me especially glad I offered my assistance.

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


"Alan Auerbach" wrote in message
...
Dear Jon,

Thank you so very much for the link that perfectly addresses my question.

Jerry Latham referred me to you. He told me that if I post this question
on
the forum, I should cross my fingers that you see it! He was so right. You
and he have been so very helpful and generous. I cannot thank you enough!

Best wishes,
/s/ Alan Auerbach

"Jon Peltier" wrote:

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
_______


"Alan Auerbach" wrote in message
...
I have a sheet with four columns of data. The first column is date/time
information for the X-Axis. Every day, two new rows are added at the
bottom.
I have to manually change the source data range each time to include
these
newly added rows of data. Is there a way to specify that all rows
containing
data are to be included? I could specify, say, one-hundred additional
rows
but that would create a large empty area at the right side of the chart
and
unnecessarily compress the data to the left. Is there an alternate
solution?

Thanks in advance for any comments,
/s/ Alan Auerbach