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.
Here are the steps outlined in the video.
Insert Chart
1) Select table (inc header)
2) Insert ~ Charts ~ Clustered Columns
3) Size it to fit your spreadsheet
Highest Sales Value Column
1) Select C2
2) =IF(B2=MAX($B$2:$B$13),B2,NA())
3) Apply to all rows.
Highlight Sales
1) Right-click chart
2) Select Data...
3) Add
4) Set "Series values" to
='203'!$C$2:$C$13
5) OK
6) OK
7) Right-click on the orange bar chart.
8) Format Data Series
9) Set "Series Overlap" to 100%
10) Enter
11) Close Format Data Series window.
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?,
