Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points.

To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools Design tab.

You need to choose Marker Color > High/Low Point and then select the color that you want to represent.

Try it out by downloading the Excel workbook below.

DOWNLOAD WORKBOOK

Highlight High & Low Points

HELPFUL RESOURCE:

hmb_logo_01Lg

 

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

Benchmark Chart in Excel 2010 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. I will show you how to do this using Using Excel 2010. DOWNLOAD EXCEL WORKBOOK STEP 1: Enter your data into three ...
XY Scatter Chart: Related Variables When you want to find out whether or not 2 variables are related or correlated, then an XY Scatter Chart should be used to plot the graph. Related variables will show up on the graph as dots that are almost in a straight line.  Examples of variables that have relationships cou...
Excel Chart Marker Options 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 sel...
Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...