Series class error

[Heather]

Am using a macro to create charts from table data.

I keep getting this error message when Excel goes to
produce the chart:

Unable to get the points property of the Series class

Can anyone help?!

 

[Jon Peltier]

Heather -

What is the line of code that gives this error? Post a subset of your
macro that includes several lines, leading up to this point.

- Jon

 

[Heather]

Jon,

Here are the lines of code before and after the line of
code with the error (which is ActiveChart.SeriesCollection
(ISeries).Points(arrVolCap(i)).DataLabel.Select).

Is this any help?

Rgds
Heather



'Find position of bottom row of data
pos = ActiveChart.SeriesCollection(1).Points
(1).DataLabel.Top

''Moves the labels for Vol Cap to bottom
For i = 1 To r
ActiveChart.SeriesCollection(ISeries).Points(arrVolCap
(i)).DataLabel.Select
Selection.Top = pos - 20
Next

'Update legend
ActiveChart.HasLegend = False
ActiveChart.HasLegend = True
ActiveChart.Legend.LegendEntries(1).Delete
ActiveChart.Legend.LegendEntries(ISeries - 1).Delete

 

[Jon Peltier]

Heather -

Check to make sure SeriesCollection(ISeries) is a valid series (try to
select it, for example), and that .Points(arrVolCap(i)) is a valid
point. Is arrVolCap and array of integers or longs?

- Jon