Excel Sparklines: How to Display High and Low Points

Yes. In Excel for Microsoft 365 on Windows, select a sparkline, open the contextual Sparkline tab, and in the Show group check High Point, Low Point, or both. Excel then highlights the highest and lowest values in that sparkline’s source data, making turning points easier to spot without adding a full chart.

What high and low points mean in a sparkline

A sparkline is a compact chart displayed inside a worksheet cell. It summarizes a row or column of values, such as monthly sales or daily temperatures, while leaving the underlying numbers in their original cells. Line, column, and win/loss are the three sparkline types available in Excel.

The High Point and Low Point settings mark the maximum and minimum values in the data used by the selected sparkline. They identify extremes within that sparkline’s own source range, not necessarily the highest or lowest values in the entire worksheet. If two values tie for the maximum or minimum, Excel can mark the tied points; the marker color helps distinguish them from the other data.

These highlights are useful when a compact trend is visible but a reader needs to find its peak or trough quickly. For example, a sparkline beside a product’s monthly sales figures can show the overall rise and fall, while a high-point marker identifies the strongest month. The markers do not add labels or display the underlying number, so keep the source figures nearby if readers need exact values.

Create a sparkline before highlighting its extremes

If the worksheet does not already contain a sparkline, create one first. In the Windows desktop version of Excel, use this process:

Select the cell or cells where you want the sparklines to appear. For a row-by-row report, select one blank destination cell for each row of data.
Choose Insert > Sparklines, then select Line, Column, or Win/Loss.
In the dialog box, enter or select the Data Range containing the values to summarize.
Enter or select the Location Range, which is where Excel will place the sparklines, and click OK.

For example, if January through December values for a product are in B2:M2, you might place that product’s sparkline in N2. Select N2 as the destination and B2:M2 as the data range. For several products, select a matching set of destination cells and source rows so each sparkline summarizes the corresponding product.

After creation, click a sparkline cell to reveal its contextual ribbon tab. In some Excel builds the tab may be labeled Sparkline Design; use the tab that appears when the sparkline is selected. The ribbon tab is contextual, so it will not normally appear when you have selected an ordinary cell.

Turn on the high and low markers

To display one or both extremes, click the sparkline or select the sparkline cells you want to format. Open the contextual Sparkline tab and find the Show group. Check High Point to mark the largest value, check Low Point to mark the smallest value, or check both. The display updates in the worksheet as you change the options.

If your sparklines are grouped, selecting one member may select the whole group. Grouped sparklines share formatting and axis settings, which is convenient when each row represents a comparable series. If only one sparkline should have the markers, select that sparkline on its own; if selection still includes its neighbors, use Sparkline > Group > Ungroup before formatting it. You can group the sparklines again later if you want shared settings.

Excel does not require a separate chart or a formula to identify the extremes. The markers are a display option; they do not change the source values or calculate new values in worksheet cells. Turning the option off removes the emphasis but leaves the sparkline and its data intact.

Choose marker colors that are easy to read

By default, a highlighted point may not stand out enough against the sparkline’s existing color, especially when the worksheet uses a dark theme or the line is thin. With the sparkline selected, open Sparkline and choose Marker Color. The menu includes options for specific point types, including High Point and Low Point. Choose a distinct color for each if readers need to tell the peak from the trough immediately.

For instance, a blue sparkline could use a green high-point marker and a red low-point marker. Make sure the colors remain visible against the cell fill and are not so similar that the two markers are hard to distinguish. If both extremes occur at the same position because the series has only one value, or because all its values are equal, there may be no meaningful visual distinction between a high and a low.

The Sparkline Color control changes the line or column color; Marker Color controls point markers. These are separate settings. The general Markers option can show markers for all points in a line sparkline, while High Point and Low Point emphasize only the extremes. Using every-point markers together with extreme markers can make a dense series look crowded, so compare the result at the size it will be read.

Read the highlighted points in context

A high or low point is only meaningful relative to the data range assigned to its sparkline. If one sparkline covers January through June and another covers July through December, their markers identify the extremes in separate periods. They do not identify the maximum or minimum across both periods combined. To compare a whole year, give each relevant sparkline the intended full-year range or compare the underlying values directly.

Also check what the source values represent. A low value may be a genuine trough, a missing-data placeholder such as zero, or an outlier caused by an entry error. Excel treats numeric zeros as values; it does not know that a zero might mean no measurement. Review the source cells before drawing conclusions from a highlighted minimum.

For a line sparkline, the marker indicates where an extreme occurs along the sequence. The order of the source data therefore matters: arranging months alphabetically instead of chronologically would produce a misleading trend. A column sparkline can make the largest and smallest columns clear, while a win/loss sparkline is designed to distinguish positive and negative outcomes rather than show the size of each value. If magnitude matters, line or column is usually more informative than win/loss.

Check axis scaling when comparing series

Separate sparklines can use different vertical scales. Excel’s automatic scaling may make modest changes in a low-range series look as dramatic as much larger changes in a high-range series. A high-point marker still identifies the highest value in its own source range, but the apparent height of the point is not a reliable way to compare its numerical size with a point in another independently scaled sparkline.

When the purpose is to compare several series, select the relevant sparkline cells and use the Sparkline tab’s Axis options to review the vertical-axis minimum and maximum settings. Options to use the same minimum or maximum for all sparklines in a group can make their visual scales more comparable. A shared scale may, however, flatten a series whose values occupy only a small part of the overall range. Choose the scale based on the comparison readers need to make, and show the source numbers when exact differences matter.

Axis choices do not change the values or which source value is highest or lowest; they change how the sparkline is drawn. This distinction helps avoid a common mistake: interpreting a tall-looking peak as a larger number than a peak in another sparkline when the two use different scales.

Common problems and quick fixes

The Sparkline tab is missing: Click a cell that actually contains a sparkline. Selecting the source numbers or a blank destination cell will not show the sparkline-specific ribbon controls.
The wrong point is highlighted: Confirm the data range and its order. A sparkline summarizes its assigned range, so an accidentally included total, blank-filled period, or unrelated value can change the maximum or minimum.
The marker is difficult to see: Use Marker Color > High Point or Low Point to choose a contrasting color. Also check the cell fill and sparkline color.
Every sparkline changes when one is formatted: The sparklines may be grouped. Select only the intended sparkline or use Sparkline > Group > Ungroup to give it independent formatting.
The trend appears exaggerated: Review the vertical-axis settings and compare the source values. Independent automatic scales can magnify small differences visually.
A blank or zero appears to create an unexpected trough: Check whether the source cell contains a true zero, is empty, or contains a formula returning an empty string. Excel’s handling of empty cells and hidden data can be reviewed through the sparkline data options, but a numeric zero is still a plotted value.

When a sparkline is not enough

Sparklines are best for quick, space-saving summaries in a table. They have limited room for labels, annotations, and context. If readers need exact dates, value labels, a visible axis, or several data series on the same scale, use a regular chart instead. A chart can make units and comparisons clearer, though it takes more worksheet space.

You can also pair a sparkline with nearby columns for the period and value of interest. That is often clearer than expecting a tiny marker to communicate an exact result. For example, keep the monthly figures in the report and add a separate column for the month with the highest sales. The sparkline then provides a visual overview, while the text gives a precise answer.

On Excel for Mac, the same general approach applies: select the sparkline and use its contextual ribbon tab to access the display and color options. Ribbon labels or arrangement can differ slightly by release. In Excel for the web, available controls can vary, so if a specific sparkline formatting option is absent, open the workbook in the desktop app.

Frequently Asked Questions

Can I show both the high and low points in one Excel sparkline?
Yes. Select the sparkline, open the contextual Sparkline tab, and check both High Point and Low Point in the Show group.

Can I change the color of only the high or low point?
Yes. Select the sparkline, choose Sparkline > Marker Color, and choose the color option for High Point or Low Point. This is separate from changing the overall sparkline color.

Do high and low markers display the exact values?
No. They highlight the locations of the extremes but do not add numeric labels. Keep the source data visible or use a regular chart or adjacent text if the exact value needs to be read.

Why do my sparklines look different even when their values are similar?
They may have different vertical-axis scales. Review the Axis options and consider using the same minimum and maximum for the sparkline group when visual comparison is the goal.

Do sparkline markers change the worksheet data?
No. High and low points are visual formatting options. They do not alter the source values, add a calculation to the sheet, or change the sparkline’s data range.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.