Skip to main content
Question

Percentage and Totals of a Stacked Bar


GeoffBarrenger
Forum|alt.badge.img+5

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!