Pinterest Pixel

Add High & Low Points in an Excel Sparkline

John Michaloudis
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.

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


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  How to Switch X and Y Axis in Excel

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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...