PDA

View Full Version : Solved: Chart formatting with VBA



leal72
02-17-2010, 12:16 PM
I am wanting to change the format of a data series. I have tried to record the macro to try and find the code I need that way but all that gets recorded is when I select the series. I do not want the effect the marker style, only change the line style from solid to dash

Bob Phillips
02-17-2010, 12:28 PM
With ActiveChart.SeriesCollection(1).Border
.ColorIndex = 57
.Weight = xlThin
.LineStyle = xlDash
End With

leal72
02-17-2010, 02:13 PM
thanks again!