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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature.There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle.Here is how you insert a Radial Cy...
Apply Custom Chart Styles Excel's default Charts are bland and ugly but you can certainly spice them up to your liking.Using the Shape Styles group in the ribbon menu you can customize your Excel chart the way you or your boss wants.There are several formatting options including Shape Styles, Shap...
Replace Excel Formatting with Another Formatting Imagine this, you have a table full of bold text.  The bold text could also be all over your worksheet in random cells.Then you decide that the bold text does not suit your expected design and prefer red colored text instead.What would you do?Changing all of the forma...
Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt.To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...