Side by side bar charts for each of 11 departments would be too many. I would show how GM changed for each department this year vs previous year with a waterfall chart:
- Calculate GM% change this year vs previous year
- Create a waterfall chart that shows regular priced GM% change for each department
- Create a waterfall chart that shows sale items GM% change for each department
- Add total to show GM for the entire business
So the result waterfall chart viz for regular priced items would look like this:
It is right away clear that department #3 has the highest increase in GM. And I would add the same viz for sale priced items right under this one. This let's user easily identify the biggest change.
Hope this helps!
Thank you so much this worked perfectly!!!
I'm glad I could help!