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

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...
Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points. To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values. Below I sho...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization: Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can! To create an Excel Table you need to highlight your data and press CTRL+T See Tutorial Here Once you have your Excel Table you can add your Excel Sparklines inside one Column and us...