Is it an XY or Line chart? Does the series have no valid plottable data
(i.e., only blanks or errors)?

Temporarily convert the series to another type (area or column), assign the
data, than change the type back.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Alistair F" wrote in message
...
The error message is:

Run time error 1004

Unable to set the Values property of the Series class

Cheers

Alistair

"Jon Peltier" wrote:

It would help to know which error you see.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Alistair F" wrote in message
...
I'm having trouble trying to modify the Values property of a SERIES
object
for an embedded chart. I've tried vaious permutations around statements
such
as

ActiveChart.SeriesCollection(3).Values = ranSchValuesRange

ranSchValuesRange is a Range object set to the values to be used by
the
SERIES object. I've tried using the ARRAY definition as well and this
makes
no difference. I keep getting the error message

Unable to set the Values property of the Series class

I'm sure I've used this type of statement before but for a Chart sheet
but
I
keep running into difficulties trying to replicate some procedures for
embedded charts.

Any suggestions?


Thanks in anticipation.