Simple Stacked Bar Chart

[UptonOGoode]

I cannot seem to make this work as I want it to. I have 4 numbers (A used, A total, B used, B total) that I would like to display as two stacked bars to give a graphical representation of how much is used of the total. Thanks in advance!

[ben_hensel]

A1 = "Name for A" // text
A2 = A used
A3 = A total
A4 = A3 - A2 // Remaining A

B1 = "B Name" // text
B2 = B used
B3 = B total
B4 = B3 - B2 // Remaining B

Then select A1:B4

Insert => stacked column chart
A1:B1 should be the labels on the x-axis

Then delete series two (A3:B3) if you want the total height of the stacked columns to go to the total amount.