Learn how to highlight the highest and the lowest in a bar chart.
Here are the steps outline in the video.
Create Min Column
1) Select cell D3
2) =IF(C3=MIN($C$3:$C$14),C3,"")
3) Apply formula to rest of the rows
Create Max Column
1) Select cell E3
2) =IF(C3=MAX($C$3:$C$14),C3,"")
3) Apply formula to rest of the rows
Insert Bar Chart
1) Ctrl + A
2) Insert ~ Charts ~ Insert Column
3) Unclustered Column
4) Reposition and resize
Overlap Bar Chart
1) Select blue bar chart.
2) Right-click, select "Format Data Series..."
3) Series Option
4) Series Overlap = 100%
Change Bar Chart Color
1) Select gray bar
2) Fill & Line, expand Fill
3) Red
4) Select Orange bar chart
5) Change fill to Green
6) Select Blue bar chart
7) Change it to gray
Highlight Minimum Value
1) Select Total Sales
2) Home ~ Style ~ Conditional Formatting
3) Manage Rules...
4) New Rule...
5) Use a formula to determine which cells to format
6) =C3=MIN($C$3:$C$14)
7) Format
8) Fill tab
9) Select Green
10) OK
11) OK
Highlight Maximum Value
1) New Rule...
2) Use a formula to determine which cells to format
3) =C3=MAX($C$3:$C$14)
4) Format
5) Fill tab
6) Select Red
7) OK
8) OK
9) OK
🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Highlight Highest and Lowest in Bar Chart - Part1 - Excel Tips and Tricks
https://youtube.com/shorts/LAILaeR2x4U?si=e39-2Y-JWWCMV8ux
Highlight Highest and Lowest in Bar Chart - Part2 - Excel Tips and Tricks
https://youtube.com/shorts/QY0JvHguDkk?si=Y3h0R6Q4Xkj4Ho3a
How do I highlight the highest value in a bar chart in Excel?,How do I highlight the lowest value in an Excel chart?,How do I make my Excel bar chart look better?,How do I highlight specific data points in Excel chart?,
Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/
#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypã‚· #exceltips #exceltricks
