VBA access to a series, after it was 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

Access to a series, when it is assigned to an empty range 0
Using Range names in selecting chart series. 1
[Q] How to create new worksheets based on an array (via named range) 4
adding a data series to a chart with variable inputs. 2
Bubble Chart 1
Help using indirect addressing in chart series 2
bubble Chart bubblesize problem in VBA 3
Convert Error Bars to Series and Colour 1

Top