Stacked bar labels

[edeaston]

Hi,

I am looking to make a stacked bar chart which will show the duration for 4
intervals for 2 different groups which is fairly straight forward. The
problem I have is that I want to display labels on the graph for both the
duration and the number of projects involved in that calculation e.g.
duration x = 2 years which is the median from 5 projects.

The data that I have looks like this:
Duration (D) 1 D 2 D 3 D 4 Projects (P) 1
P2 P3 P4
Big 1.3 2.1 3.4 0.9 12
9 6 3
Small 1.5 1.9 3.0 0.6 34
16 10 5

I think I will need to set up a macro to create the labels but I am really
not sure how best to do this.

Cheers

Ed

 

[edeaston]

Just to clarify my previous question the way I would like to display the n
numbers would be to have it in brackets after the value label so that each
section of the bar would have x (n) displayed.

Also the example datasheet lost its formatting and looks like:
Name D1 D2 D3 D4 P1 P2 P3 P4
Big 1.3 2.1 3.4 0.9 12 9 6 3
Small 1.5 1.9 3.0 0.6 34 16 10 5

Thanks

Ed