Workout Wednesday | Week 48: Profitability Bridge

I'm a bit behind again on Workout Wednesday, you know, this whole life thing. Today I had a few minutes to look at week 48. As it was a waterfall chart with a couple of other tricks thrown in, I thought it would be pretty straightforward, and it was...thank goodness.

The basic requirements:

• Create a waterfall chart showing the top 5 sub-categories by sales. Include an other category for all other categories.
• Show a bar on the far-left of the waterfall that shows all sub-categories. Label it all.
• Add dashed lines that “connect” each bar.
• Add a dashed line that connects the All bar with the Other bar.
• Make sure each line looks as a single continuous dashed line. 
• Label each sub-category above the bottom line of each bar.
• Label each bar with the profit ratio below the bottom line of each bar.
• Add a filter by region. Make sure the filter is centered on the dashboard above the chart.
• Color the bar gray if it above zero or pink if it is below zero.