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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own.A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc.We are going ...
Clustered Bar Chart: Year to Date Sales If you want to compare your Year to Date sales and have category names (eg. products, business names, channel partners, sales reps etc)  which are way too long, then the Clustered Bar chart is the one for you.In the example below the category names relate to companies and I a...
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...
Save A Chart Template Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template.So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it s...