Series reference on a chart

  • Thread starter Thread starter kev_06
  • Start date Start date
K

kev_06

I'm trying to reference a series on a chart with seriescollection(). Ho
can I find out what the index number of the series is? I've tried usin
the name of the series, but I can't seem to get it to work
 
Example:

Sub GetChartSeries()
Dim s As Series
Dim cht As Chart
Set cht = ActiveSheet.ChartObjects(1).Chart
Set s = cht.SeriesCollection("Sales Data")
s.Border.ColorIndex = 5
s.Fill.ForeColor.SchemeColor = 5
End Sub

Regards,
Greg
 

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

Selected series in chart 2
SeriesCollection(2).Formula returns formula for series 1 1
How to add series to a chart using a macro 12
can't delete a series from SeriesCollection ??? 2
Chart - Variable Series Collection 3
Delete chart series 2
iterate through chart series collection 8
.Seriescolection(n).formula - size limitation? 5

Back
Top