Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi again Mark,
If you want to put that into a loop for several points then something like this:- Dim p As Long For p = 4 To 7 With Worksheets("Sheet1").ChartObjects("Chart 1").Chart.SeriesCollection(1) With .Points(p).Border 'Formats from point 3 to point 4 .ColorIndex = 3 .Weight = xlThin '.Weight = xlThick 'Included for info .LineStyle = xlContinuous End With End With Next p -- Regards, OssieMac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Points on Line Chart | Charts and Charting in Excel | |||
Conditionally Format Data Points in Line Chart | Charts and Charting in Excel | |||
How to format a line between two points? | Charts and Charting in Excel | |||
Line chart with two series; how to add points to one and not the other? | Charts and Charting in Excel | |||
Null points in a line chart | Excel Discussion (Misc queries) |