Pick one of these techniques:

http://peltiertech.com/Excel/ChartsH...html#addseries

and put it into a loop which iterates each series.

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

wrote in message
oups.com...
Thanks Jon. I actually visited your site before posting, but I'm still
a little confused.

Here's what my data looks like:

date1 date2 date3
seriestitle1
seriestitle2 series data range A
seriestitle3
----------------------------------------------------
seriestitle4
seriestitle5 series data range B
seriestitle6

I have used VBA to identify the ranges corrseponding to A and B. I
could use the setsourcedata method to graph data range A with titles
and dates. But I can't do that for data range B.

Your website says, "You are not limited to using SetSourceData to
define the data being charted. You can add the series one-by-one,
selecting the precise data you want, not what Excel will assume you
want." It would be extremely helpful if you could give me a hint on
how to do this.