Access to a series, when it is assigned to an empty range

W

Werner Rohrmoser

Hello,

I'd like to get access to a chart series via vba.
This works fine with
ActiveChart.SeriesCollection(1).Values =
"='" & ActiveWorkbook.Name & "'!" &
Diagramm1.Range("Chart1_Series1").Value
this is a reference to a named range.
So, if I assign the series to a range with values I can change the
series to another range afterwards.
But if I once have assigned a series to an empty range I do not have
access to the chart series any more.
The error message is:"unable to set the values property of the series
object"
Only manually it's possible to reactivate this series, then I can
continue to run vba

Does anyone have a workaround?

Excel XP SP 3
Windows XP SP 3

Regards
Werner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA access to a series, after it was assigned to an empty range 0
Generate series according to range and increment 5
Convert Error Bars to Series and Colour 1
Automatize chart building 1
unable to set the values property of the series class 3
How to change empty ranges from a plot series without generating e 0
Using Range names in selecting chart series. 1
Overlaying 2 Data Series with Different Time (X) Axis 3

Top