How to mark the minimum/maximum value in an Excel chart?

How to mark the minimum/maximum value in an Excel chart? Using charts is one of the most effective ways to visually represent data. The visual effect will be even better if you can highlight the maximum and minimum values on that chart. Read on to learn how to mark Min/Max points on an Excel chart.

Create a chart and mark the Min/Max points on the chart

Create a chart

Assuming you want to draw a chart representing the revenue of the following products:

How to mark the minimum/maximum value in an Excel chart?

To draw a chart, follow these steps:

Step 1: On the toolbar, select the Insert tab.

Step 2: Choose the Insert Line or Area Chart icon.

Step 3: Choose the chart you find suitable and want to use.

In this example, we will choose the line chart. After choosing, the chart will be displayed as follows:

How to mark the minimum/maximum value in an Excel chart?

Mark the Min/Max points on the chart

How to mark the minimum/maximum value in an Excel chart?

To be able to mark Min/Max points

first, we need to find the maximum and minimum values ​​in the data table.

To find the minimum value, in the first cell, enter the following command: = IF(B2 = MIN($B$2:$B$7), B2, NA())

Where:

+ B2 is the cell containing the value to be compared.

+ $B$2:$B$7: The range contains values ​​to find Min/Max. This data range must be fixed so that when copying down the cells, it will not shift. Therefore, after selecting this range, press F4 to fix it.

How to mark the minimum/maximum value in an Excel chart?

After pressing Enter, copy it to the cells below. If it is not the minimum value, Excel will return #N/A, and it will return the value of the corresponding cell if it is the minimum value.

To find the maximum value, you do the same, but we will use the Max function. Enter the following command: = IF(B2 = MAX($B$2:$B$7), B2, NA())

How to mark the minimum/maximum value in an Excel chart?

Then copy the formula down to find the maximum value.

Once done, we will start displaying these 2 Min and Max points on the chart. Follow these steps:

Step 1: Click on the chart just created above. At this time, the data range used to create the chart will be highlighted.

Step 2: Expand that data range to the 2 columns Min and Max so that these 2 columns are also highlighted.

After finishing, we will see 2 points marked on the chart as shown below. These are the Min point and the Max point.

How to mark the minimum/maximum value in an Excel chart?

Format the chart

After displaying the 2 Min and Max points, we will format them to make them more visually appealing through some steps as follows.

First, we will change the color, shape, and size of these 2 points:

How to mark the minimum/maximum value in an Excel chart?

Step 1: Click on the chart, then press Ctrl + 1. The Format Data Series dialog box will appear.

Step 2: Select the Series Options item. Then, to format the Min point, select the “Min” Series, and conversely, to format the Max point, select the “Max” Series.

How to mark the minimum/maximum value in an Excel chart?

Step 3: Click on the Fill & Line icon to select Marker. Then select Marker Options to change the format. Here, you can change the icon, color, border, icon size, etc.

How to mark the minimum/maximum value in an Excel chart?

Next, we will display the values of the 2 Min and Max points on the chart.

Step 1: Right-click on the Min (or Max) point. Then select Add Data Labels. The value of the Min (Max) point will now be displayed on the chart.

How to mark the minimum/maximum value in an Excel chart?

Step 2: Right-click on the value, then select Format Data Labels.

How to mark the minimum/maximum value in an Excel chart?

When the Format Data Labels dialog box appears, set the Label Position as follows:

Select Above for the Max point to display the value above it.
Select Below for the Min point to display the value below it.

How to mark the minimum/maximum value in an Excel chart?

The final result is illustrated in the figure below:

How to mark the minimum/maximum value in an Excel chart?

Above are the steps to mark Min and Max points on a chart in Excel. We invite readers to refer and apply them. Wish you success.