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. <br /><br /><br />How do I highlight specific data points in Excel chart?,How could you dynamically format the highest value in a chart?,How do you find the peak value in Excel?,How do you show the minimum and maximum on an Excel graph?, <br /><br />
