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 WORKBOOK

 

HELPFUL RESOURCE:

hmb_logo_01Lg

 

5

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