In your goofing around did you check out the XValues and Values
properties of the Series object?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article .com,
says...
Suppose I have three range objects, call them XRange, DataRange and
DataLabelsRange.

- XRange is a series of months, e.g. Jan 2005, Feb 2005 ... etc.

- DataRange contains several series of data for each month. For
example data for North Sales, South Sales, etc.

- DataLabelsRange contains the actual labels "North Sales", "South
Sales", etc.

The goal is use VBA to create a chart from this ranges with the months
on the x axis, lines for each of the series on the y axis, and a legend
labeling the lines for you. Pretty simple, no? But after goofing
around with the seriescollection object for a couple of hours I can't
figure it out.

For reasons I won't go into, I can't just select these three ranges as
one block and have Excel figure out the rest. I need to take these
three separate ranges and somehow meld them into a graph using VBA.

Any advice would be much appreciated--thanks!