automate 2dline with marker chart generation - Excel 2007

K

kdilly

In generating line charts with markers, I can change the color of the
markers, but not the marker lines and series lines. The VBA code for the
markers is:

.SeriesCollection(1).Select
With Selection
.MarkerStyle = xlDiamond
.MarkerSize = 9
End With
.SeriesCollection(1).Format.Fill.ForeColor.RGB = RGB(255, 200, 25)

What are the references for the marker lines and the lines between the
series points?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top