How to create stacked columns with distribution incorporated

I am baffled with the challenge of creating stacked columns with distribution incorporated.

The "score" should be reflected on the primary axis and the "score distribution" should be stacked within the "score" bar.

This must be possible?

I've attached my file for reference.

Thanks

Originally Posted by Vbort44

I am baffled with the challenge of creating stacked columns with distribution incorporated.

The "score" should be reflected on the primary axis and the "score distribution" should be stacked within the "score" bar.

This must be possible?

I've attached my file for reference.

Thanks

This site may be helpful for you:
http://peltiertech.com/Excel/Charts/...s.html#StakCht
Goodluck

Perfect, thanks!