Line graph markers

Hi Luke

Thanks for getting in touch. Unfortunately it's not possible to select multiple lines in Excel charts without coding.

I will provide you with some code which you can customise as you need.

To program this with VBA, when in your workbook press ALT+F11. Go to Insert > Module and paste the following:

Sub FormatLineMarkers()

Dim objSeries As Series

With ActiveChart
For Each objSeries In .SeriesCollection
objSeries.MarkerStyle = 1
objSeries.MarkerSize = 9
Next
End With

End Sub

Then click on your chart, go to View > Macros > FormatLineMarkers.

This code will loop through every line in a chart, change the style to a square and size 9. The code will need to be adapted depending on what you need to modify. The best way to do this is to record a macro performing the change on one line, then pasting that into the code above.

I'm not sure how comfortable you are with modifying VBA code, so if you let me know what you're trying to format on your charts I can offer some more guidance.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector