What do these strings look like? Are they valid for this use?
strPrefix & SeriesStartRow & "C" & SeriesColumn
strPrefix & SeriesStartRow & "C" & XValueColumn & ":R" & SeriesEndRow & "C"
& XValueColumn
strPrefix & SeriesStartRow & "C" & DataColumn & ":R" & SeriesEndRow & "C" &
DataColumn

What kind of chart is it? What is the initial source data? Valid numbers and
labels, or blanks, or what?

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


"Dale Fye" wrote in message
...
I have a function that loops through a dataset and dynamically builds the
chart series for a bunch of charts. 95% of the time, this function works
properly, but occassionally, I get an error that reads "Unable to set the
.... property of the Series class", where the ... represents Name,
XValues,
and Values.

Some of the sheet names contain spaces, so I encapsulated them in single
quotes, which seems to work most of the time.

The code that is generating the problem looks like:

strPrefix = "='" & ActiveSheet.name & "'!R"
ActiveChart.SeriesCollection(SeriesCount).Name = strPrefix &
SeriesStartRow
& "C" & SeriesColumn

ActiveChart.SeriesCollection(SeriesCount).XValues = strPrefix &
SeriesStartRow & "C" & XValueColumn & ":R" & SeriesEndRow & "C" &
XValueColumn

ActiveChart.SeriesCollection(SeriesCount).Values = strPrefix &
SeriesStartRow & "C" & DataColumn & ":R" & SeriesEndRow & "C" & DataColumn


--
Email address is not valid.
Please reply to newsgroup only.