Bar chart solution please

[#1]

Location	UNIT	SEATS	HC	VAC
Chicago	Warehouse	100	70	30%
Chicago	Shop	50	25	50%
Washington	Mall	200	80	20%
Washington	Corporate	100	50	50%

I need Stackable bar chart by Unit by Location ( Ex : at location Chicago there are 150 seats,95 hc and 37% vacancy)

Each stack in a bar should show total of seats and HC  and a bubble or check box to show Vacancy%.Pimary x- axis value should show Seats and Empty Seats and secondary x-axis value should show vacancy %.Not sure if this is possible.

Thanks,

Alva.

[sunny_talwar · Accepted solution]

This?

[sunny_talwar]

How are you getting a vacancy of 37% at Chicago location?

[settu_periasamy]

Hi Sunny,

I think it should be (3rd exp)

=1-Sum(HC)/Sum(SEATS)

Number format (%)

- but not sure, this is what he needs..

[sunny_talwar]

Makes sense

[#6]

Thank you.I think this is almost what they need.Thank you very much.

[sunny_talwar]

Awesome