Percentage and Totals of a Stacked Bar
We're tracking our productivity through actions taken during the week. Each week has a total of actions taken, a sum of both the blue and red portions of the below chart. The Blue actions were scheduled - ie: we knew and planned ahead. The red actions were last minute urgent requests that came in. These are unfortunately unavoidable - but we'd like to keep this number in the 5-7% range. Is there anyway in a stacked bar to show the percentages of the series as they relate to their summary? I'd also like to see a total of the stacked bar. I'm not sure if this is possible with some sort of summary formula, but would be very helpful!
