Thanks Dave, I ended up figuring it out before I saw your post.

The way I did it was to Dim a range, then Set that range equal to a
entire column using A1 references, like this:

Set TimeRange = Range("B:B")

Then when the SeriesCollection is set for the chart, I replaced th
R1C1 reference that had been recorded for the macro. It looked like:

SeriesCollection.XValues = (=rangedata!R1C2:R1C4332)

I changed that to simply:

SeriesCollection.XValues = TimeRange

Basically, I just didn't understand enough about how ranges work an
how the series collection was being defined. I got some help from th
Excel 2000 Bible in that regard, which I was able to search through fo
free at Amazon. I've ordered the book since it was so helpful.

Hopefully this info will help other beginners with similar problems

--
Message posted from http://www.ExcelForum.com