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

Add an Interactive Vertical Column in Your Excel L... With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar!The reason why I do this, is to use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholde...
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...
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...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...