Pinterest Pixel

Add High & Low Points in an Excel Sparkline

Excel Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Add High & Low Points in an Excel Sparkline | MyExcelOnline Add High & Low Points in an Excel Sparkline | MyExcelOnline

Excel Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Excel 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.

Add High & Low Points in an Excel Sparkline | MyExcelOnline
Download workbookHighlight-High-Low-Points.xlsx

 

MATCH Function Intro

 

If you like this Excel tip, please share it
Add High & Low Points in an Excel Sparkline | MyExcelOnline Add High & Low Points in an Excel Sparkline | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Excel Chart Template Infographic

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...