Dear Jon,

Perhaps I can add something to the discussion.

I am certain this will be obvious to you, but it was not to me so it might
help someone else who reads this thread.

In my chart, not every cell contains data. Some values are updated
once-a-day while others are updated twice-a-day and still others weekly.
Since the date and time values are present in every row, they can be used to
select the number of rows. In this case, I merely used that column (A, in my
case) to derive the COUNTA value rather than a colum with data points. In
this way, the graph included values in every row and can trend between values
(or simply data-point) for those columns in which not all cells contain
values. All that is necessary is to use the formula in the example you
provided but maintain the COUNTA references the same for each data source,
regardless of the column in which the data appears.

I hope that this comment is of some value. :-)

/s/ Alan Auerbach

"Jon Peltier" wrote:

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