Visualize year over year data in Excel – Excel Tips and Tricks

Visualize year over year data in Excel – Excel Tips and Tricks

Learn how to visualize year over year data in Excel.

Here is the formula to calculate year-over-year

YOY Calculation
=(D5-C5)/C5

YOY Chart
1) Select Month and YOY column
Press Ctrl when selecting YOY column
2) Alt + F1
3) Chart Design ~ Change Chart type ~ Bar
4) Clustered Bar
5) OK
6) Resize and reposition

YOY Chart Styling
1) Add data label
2) Right-click month axis ~ Format Axis…
Category in reverse order
Label Position set to Low
3) Select data label
Label Option ~ Label Position=Center
4) Select bar
Label Option ~ Gap Width=20%
Fill=Light Green
Negative if inverted checked
Fill color=Red

#tips #excel #shorts #fyp

Close Menu