View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Arne Arne is offline
external usenet poster
 
Posts: 35
Default VBA chart formatting

Peter,

Using the Border property of SeriesCollection(i)

The object browser shows Border is a property of SeriesLines which is a
property of ChartGroup. the help system says:

With Charts("Chart1").ChartGroups(1)
.HasSeriesLines = True
With .SeriesLines.Border
.LineStyle = xlThin
.Weight = xlMedium
.ColorIndex = 3
End With
End With

I was able to change the series line formatting with
SeriesCollection(i).Border

Arne