Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy chart formatting and chart templates in Excel 2007 | Charts and Charting in Excel | |||
Chart formatting | Excel Discussion (Misc queries) | |||
Pivot Chart Refresh cancels all chart formatting | Charts and Charting in Excel | |||
chart formatting | Excel Programming | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |