Stacked bar chart with a marker

[mpm32]

Two questions;

I have a stacked bar chart - all the bars add up to 1. The chart shows the percentage of a task completed in pass 1, pass 2 and the remaining percentage left to complete the task.

I would like to add a marker (a diamond) at a goal percentage for each bar. I have done something similar with a plain bar chart but can't sort it out for a stacked bar.

Secondly, in the three categories I have for each bar, Pass 1, Pass 2 and remaining, I would like the data label for Pass 2 to show the total of Pass 1 and 2.

For example; Team 1 has .14 for pass 1, .10 for pass 2. The data labels say .14 and .10. I would like them to say .14 and .24. I can make a label for this but I would rather have it done systematically.

My data set looks like this;

	 Pass 1	 Pass 2	% Remain Recommended %
Team 1	 0.14	 0.10	  0.76	  0.67
Team 2	 0.57	 0.23	  0.21	  0.58
Team 3	 0.34	 0.38	  0.28	  0.70
Team 4	 0.43	 0.31	  0.26	  0.68
Team 5	 0.23	 0.04	  0.73	  0.70
Team 6	 0.32	 0.01	  0.68	  0.71
Team 7	 0.17	 0.02	  0.82	  0.73
Team 8	 0.00	 0.20	  0.80	  0.74
Team 9	 0.00	 0.13	  0.88	  0.76
Team 10	 0.00	 0.00	  1.00	  0.77
Team 11	 0.00	 0.13	  0.88	  0.79

Thanks in advance!

 

[SkipVought]

Hi,

You need 4 columns

% Remain %to go Recommended % %rec to go

both pairs add up to 1

% Remain %to go on primary axis

Recommended % %rec to go on secondary axis

two series if BEHIND the other two. the series behind have ZERO gap width.




Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

I'd switch the pairs' columns around BEFORE inserting the chart and put the recommended pair in the primary axis and the remaining pair on the secondary axis.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]