Learn how to highlight only the highest value in the chart. In other words, how do I highlight specific data points in excel? Or how could you dynamically format the highest value in a chart? This technique can also be used to find the peak value in Excel. We can also extend the same technique to show minimum and maximum value on the Excel graph. br br Here are the steps outlined in the video. br br Insert Chart br 1) Select table (inc header) br 2) Insert ~ Charts ~ Clustered Columns br 3) Size it to fit your spreadsheet br br Highest Sales Value Column br 1) Select C2 br 2) =IF(B2=MAX($B$2:$B$13),B2,NA()) br 3) Apply to all rows. br br Highlight Sales br 1) Right-click chart br 2) Select Data... br 3) Add br 4) Set "Series values" to br ='203'!$C$2:$C$13 br 5) OK br 6) OK br 7) Right-click on the orange bar chart. br 8) Format Data Series br 9) Set "Series Overlap" to 100 br 10) Enter br 11) Close Format Data Series window.