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

Share on Google+

Google+

Related Posts

Process Map Using Excel If you want to show a process in your workplace then this can be designed using Excel´s Smart Art. There are heaps of Process Maps in Excel that shows progress from left to right, top to bottom, one way and circular.  Here is how you can insert a left to right Process Map usin...
Copying & Moving Excel Charts I am going to show your three quick ways to copy and move your Excel charts: #1 - COPYING A CHART Click on the chart with your left mouse key and at the same time hold down the CTRL key to copy it and move the chart to wherever you want. When you are done, let go of the ...
Create a Box and Whisker Chart With Excel 2016 Box and Whisker Charts are one of the many new Charts available only in Excel 2016 and were originally invented by John Tukey in 1977. They show you the distribution of a data set, showing the median, quartiles, range and outliers. The X in the box represents the Mean. ...
Sparklines: Line Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell. You can style them in different colors and add a marker for the High and Low points of your data.  As your data changes so do the Sparklines, which gives them that much more pow...