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

Download workbookHighlight-High-Low-Points.xlsx

If you like this Excel tip, please share it

email

Pinterest

Facebook

Twitter

Linkedin

John Michaloudis

Founder & Chief Inspirational Officer at MyExcelOnline.com

See also  Create a Treemap Chart With Excel 2016

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 Academy Online Course.