If you changed the source to a range name, then all you
need do is extend the range names. much simpler to do.

Create a table of the relevent range names, then all your
code needs to do is read th etable , then for each name,
resize & rename the range!

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I have an Excel workbook that has many charts in it. I
would like to create some code that allows me to
automatically manipulate the .Value and .Xvalue of the
active chart's SeriesCollection.
Each month a new data point is added to the chart's
source
data and the .Value and .XValue needs to be extended by
one column to the left (the source data is in rows) to
encompass the new data point. Does anyone have an
example
of code that could do this?

Thanks,
jNando

.