Hi, In this tutorial, let us learn how to highlight special data points in the Chart that we create in MS Excel. Let's see how to do it now: Step 1: In this example, I am considering the data of Sales in numbers by month wise in a particular year. Step 2: If we generate the Chart with the available data in two columns, it would be like as shown below: now let us highlight the MAX and MIN Data points in this chart Step 3: Let us first Calculate the MAX and MIN values of these figures at the bottom of the table, using the formulas as shown: MAX function in C16 = MAX(C4:C15) MIN function in C17 = MIN(C4:C15) Step 4: Now let us create two dummy series in two columns as " Dummy MAX Series " and " Dummy MIN Series " Enter the formula in the Dummy Max series column's first cell as = If(C4=C16,C4,NA()), this will give the result if the cell's value is the max of the series, or else it will show as NA. Similarly