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 WORKBOOK

Marker Options

 

HELPFUL RESOURCE:

Chandoo - excel-school

 

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials