Well, I am of course one to shy away from something that is a "major pain".
Can you suggest another way to have the chart title update based upon which
series is chosen? I have an X-Y scatter plot embedded in a worksheet, with
the following ranges used:

$D$3:$D$6756 (x-series) and $E$3:$L$6756 (y-series).

I like being able to change the chart simply by moving the blue selection
box from column to column. The chart title is contained in D2:L2, so I would
need the chart title to update from those cells depending upon which column
is used for the y-series. Any help is appreciated.

wazooli

"Jon Peltier" wrote:

This requires you to parse the SERIES formula, which sounds like a major
pain, unless someone tells you that John Walkenbach has a class module
you can use that simplifies all that:

http://www.j-walk.com/ss/excel/tips/tip83.htm

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


Wazooli wrote:

How do I get the series address in VBA? I want to dynamically change the
chart title based upon which column is used for the Y-values in an X-Y
scatter plot.

wazooli