In VBA, how do I access the line object of a chart's SeriesCollection? Excel's Help frightens me with "There’s no object that represents a single series line...". My immediate need is to make Series1 and Series2 be dotted lines (xlDot) for a great number of charts. Hence my desire for a VBA solution. I thought it might be something like:
myChart.SeriesCollection(1).Format.Line = xlDot
myChart.SeriesCollection(2).Format.Line = xlDot
Is there a solution?
myChart.SeriesCollection(1).Format.Line = xlDot
myChart.SeriesCollection(2).Format.Line = xlDot
Is there a solution?