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.