Pinterest Pixel

Excel Chart Marker Options

John Michaloudis
 .
Excel Chart Marker Options | MyExcelOnline Excel Chart Marker Options | MyExcelOnline

Want to know how to add chart marker options in Excel?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

Excel Chart Marker Options | MyExcelOnline

The Marker Options within an Excel chart enables you to add different marker types or shapes on your chart to distinguish a data series or its individual data points.

To bring up the Marker Options you need to click on your Excel chart and make sure that all the points are selected.  Then press CTRL+1 to bring up the Format dialogue box and within there you can choose to style and format the Markers to your liking.

You will need to play around with the different Marker styles and combinations to get your desired result but you can have lots of fun with this.

Download workbookMarker-Options.xlsx

 

 

HELPFUL RESOURCE:

Conditionally Format a Pivot Table With Data Bars

 

 

 

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Draw a Logo with a Scatter Chart in Excel

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...