Show YoY (Year-over-Year) variance using data bars in Excel - Excel Tips and Tricks

Описание: Learn how to show YoY (Year-over-Year) variance using Data bars in Excel.

Here are the steps outlined in my video.

1) Select E6:E17
2) Home ~ Style ~ Conditional Formatting
3) New Rule...
4) Format all cells based on their values
5) Format Style = Data Bar
6) Solid fill change to light green
7) Negative Value and Axis Setting
8) Select color you want
9) OK
10) OK

#excel #tips #shorts #fyp