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

Adding Data Labels To An Excel Chart Data Labels make an Excel chart easier to understand because they show details about a data series or its individual data points. Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point. In ou...
Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend. An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...
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...
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...