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






Get access to 30+ Microsoft Excel & Office courses for ONLY $1.

Click here to get this limited-time $1 offer!


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn