Possible to create a stacked and clustered column together? I'm having difficult with my data.

[SleightOfHand]

I'm not sure if I'm using the correct terminology here, but basically, here is my set of data:

Book1
	C	D	E	F	G	H	I	J	K	L
7			Demand
8			Year	2021	2029	2050		Seating Capacity	Standing Capacity	Total Capacity
9
10	Line 1			80	300	600		500	200	700
11	Line 2			70	150	200		500	200	700
12	Line 3			90	180	270		500	200	700
13	Line 4			100	250	450		400	100	500
Sheet1

I'm looking at capacity constraints for a train service. What I would like to do is have the x-axis display the four lines, with each line having a cluster of the yearsn that I have assembled. Then I'm looking to see if I can stack the actual capacity on them; so, we can see that the Line 1 has a demand of 80 people for the initial year, 300 for the next, and 600 for the final. The seating capacity here is 500, standing is 200, so total is 700. I don't know if this is possible, but for the demand of 80 for example, there would be a big chunk of bar attached to it for the seating, and a small for standing. When we get to the final year though, then the seating portion would be 'covered', so now we have standing capacity to look at for availability. I can do a rough example in Paint to see what I mean!

At the moment I can get a clustered column, but the capacity will be next to all of the years and not stacked on top. This aesthetics aren't as nice.

What we would ultimately see is four points on the axis (for the total lines) and three years per those points/lines.

I could do it in %, but I would like to do the actual numerical values and visually tell if demand is encroaching on capacity.

Thanks to all...

 

[GraH]

Hi, take a look on Jon Peltier's website. He has a tutorial on the topic. Google clustered stacked chart.