Series class error

  • Thread starter Thread starter Heather
  • Start date Start date
H

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?!
 
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
 
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
 
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
 
Back
Top