How to Show Min and Max in Excel Graph

Making your most important data points jump off the screen is one of the fastest ways to make your Excel charts more effective. Instead of forcing your audience to hunt for the peaks and valleys, you can automatically highlight the minimum and maximum values right on the graph. This article will show you a simple, dynamic method to make your charts instantly reader-friendly.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Highlight Minimum and Maximum Values?

Pinpointing the best and worst-performing points in a dataset helps you and your team answer critical questions at a glance. When you're looking at a chart of monthly sales, website traffic, or ad performance, you almost immediately want to know:

• What was our best month?
• When did performance dip the lowest?
• How big is the gap between the two?

By visually flagging these data points, your chart goes from being a passive data display to an active tool for analysis. It instantly adds context and focuses the conversation on the results that matter most, saving everyone time and preventing key insights from getting lost in a jumble of lines and bars.

Setting Up Your Sample Data

First things first, you need some data. We'll work with a simple and common example: monthly sales figures for a year. This technique works with any time-series data, whether it's website sessions from Google Analytics or leads from your CRM.

Open a new Excel sheet and set up your data like this:

Select your data (in this case, cells A1 through B13), go to the Insert tab, and choose your preferred chart. A 2-D Line or 2-D Column chart usually works best for this type of data.

You now have a standard chart. It looks fine, but finding the highest and lowest points requires a bit of scanning. Let's fix that.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: Manually Add Data Labels (The Quick Way)

For a one-off report or a quick analysis, you can simply add data labels to the min and max points by hand. This method is fast but not dynamic - if your source data changes, you'll have to manually adjust the labels.

1. Click once on the line in your chart to select the entire data series. All the data points will be highlighted.
2. Click a second time on the specific data point you want to label (for example, the lowest point in February). Now, only that single point should be selected.
3. Right-click on that selected point and choose Add Data Label from the context menu.

Repeat this process for the highest data point. You can then right-click the new data labels to format them - change the color, make the text bold, or adjust their position (e.g., "Above" or "Below" the point).

This approach works well when you're in a hurry. However, the real power comes from creating a chart that updates automatically. For an automated, dynamic solution, we need to use some clever formulas.

Method 2: Dynamically Show Min & Max with Helper Columns

The best and most flexible way to highlight min and max values is by using "helper columns." These extra columns will use formulas to automatically identify the highest and lowest values in your main data series. When your original data changes, these columns will update, and so will your chart.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Create a "Min" Helper Column

In the column next to your sales data (column C), create a heading called "Min." We are going to use a formula that checks if the sales value in each row is the absolute minimum of the entire dataset. If it is, the formula will show that value, if not, it will return an error that Excel knows not to plot.

In cell C2, enter the following formula:

=IF(B2=MIN($B$2:$B$13),B2,NA())

Let's break down this formula:

• B2=MIN($B$2:$B$13): This is the logical test. It checks if the value in cell B2 (the sales for January) is equal to the minimum value in the entire sales range (B2:B13). The dollar signs $ make the range an absolute reference, so it doesn't change as we drag the formula down.
• B2: This is what the formula returns if the test is TRUE (if B2 is indeed the minimum value).
• NA(): This is the key to the whole trick. If the test is FALSE, the formula returns #N/A. When Excel's charting engine sees #N/A, it leaves a gap and doesn't plot a point. This is crucial - if we used a 0 or an empty string ("") , Excel would plot those values as zeros, distorting our chart.

Press Enter and then drag the fill handle (the small square in the bottom-right corner of the cell) down to cell C13 to copy the formula for all months.

Step 2: Create a "Max" Helper Column

Next, we'll do the same thing for the maximum value. Create a "Max" heading in column D.

In cell D2, enter a similar formula, but this time using the MAX function:

=IF(B2=MAX($B$2:$B$13),B2,NA())

Drag this formula down to D13. Your table should now look like this, with the single min and max values isolated in their respective columns:

Step 3: Add the Helper Columns to Your Chart

Now we need to add these new "Min" and "Max" data columns to our chart as new data series.

1. Right-click anywhere on your chart and choose Select Data.
2. In the "Select Data Source" dialog box, under "Legend Entries (Series)," click the Add button.
3. A small "Edit Series" window will pop up. For the Series name, you can click on cell C1 ("Min").
4. For the Series values, delete what's there (e.g., ={1}) and select the data in your "Min" column (cells C2 through C13).
5. Click OK.
6. Repeat the process to add another series for your "Max" column, using cell D1 for the name and cells D2:D13 for the values.

After clicking OK, you might see something a bit strange on your chart — lone orange and gray dots for the min and max values. We're close, but now we need to format them properly to get the effect we want.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 4: Format the Min and Max Data Points

The goal is to have the original line chart overlaid with distinct markers for the minimum and maximum points. We'll use a combination chart to achieve this.

1. Right-click the chart and choose Change Chart Type.
2. In the dialog box, go to the Combo category at the bottom.
3. Here, you'll see your three data series: "Sales," "Min," and "Max."
4. Click OK and you're almost done!

This puts the min/max markers directly on top of the original sales line. Now let's style them to stand out.

Styling Your Min and Max Markers and Labels

A little formatting goes a long way. Let's make our minimum point red and our maximum point green, add clear labels, and remove clutter from the legend.

1. Hide the Min/Max lines: Double-click the max marker (August). In the Format Data Series pane on the right-hand side under the Fill & Line tab (the paint can icon), click "Line" and select "No line". Do the same for the min marker. Now, they only appear as markers.
2. Format the Markers: While still in the "Format Data Series" pane, click "Marker". Set the "Fill" color to green. Select "Marker Options" and choose a different "Type" (like a circle) and increase the "Size" to make it more prominent.
3. Repeat the process for the "Min" data point, coloring its marker red.
4. Add Data Labels: Right-click on the green "Max" marker and select Add Data Label. Do the same for the red "Min" marker. You can then format these labels (make them bold, change their color, or position them). Setting the label position to "Above" for the max and "Below" for the min often works well.
5. Clean Up the Legend: Your legend now includes "Min" and "Max," which is redundant since the markers are self-explanatory. Click once on the chart legend to select it. Click a second time on the "Min" legend entry to select just that item, then press the Delete key on your keyboard. Do the same for the "Max" entry.

Presto! You now have a clean, dynamic, and professional-looking chart that automatically flags your highest and lowest data points.

Final Thoughts

You’ve just transformed a standard Excel chart into a sharp, insightful visual that instantly communicates performance highlights. Using the dynamic helper column method ensures that your chart stays accurate and useful, even as the underlying data changes, saving you from repetitive manual updates.

Excel is an amazing tool, but getting your reports just right can still involve a lot of formula-writing, cell formatting, and clicking through menus. We created Graphed because we believe getting insights from your business data should be much simpler. Instead of building helper columns and formatting charts manually, you can just ask what you want to see - "show me last year's sales by month as a line chart and highlight the min and max values" - and get an interactive, live-updating dashboard in seconds.