r/excel•
master_effect

[Excel 2010] How to change the "Marker Type" in a Scatter Plot for ALL series at the same time?

Waiting on OP

Excel 2013 is amazing cause the default marker type is a circle for all series. I deal with 20-30 series across four categories, and it is helpful to show trends over 12 months when plotted in a scatter graph.

However, in Excel 2010, the default marker type is such that you have circles, crosses, X's, triangles and what not. And, for the life of me, I cannot find a way to select ALL the series and change their marker types in one go. Given than I work with 20-30 series and have four graphs to handle each month, I would sincerely not like to do it manually one by one.

Thanks!

Posted Jun 3, 2017, 4:37 PM UTC

12
Loading comments…