How to include two values in one bar for Pivot Chart

[Snowbird72]

I am hoping someone can help me with this issue.

I may not be explaining this very well but hopefully someone can decipher this for me. I have been looking everywhere to see how it would be possible to add data to bars in a pivot chart from related data.

If you look at the attached image, I have added the number of units to the bar chart manually. The bar is based on a summary of areas related to units but I would also like to have the total number of units represented within the total area.

For example, 2017-Q3 has a total of 202,788 sf of area becoming available. This total is taken from the Quarterly Available data point from a sharepoint list. Another data point is the Related Units. The summation of the areas for Related Units by quarter is what makes up Quarterly Available areas (i.e. 202,788 sf). But I would like to also know, without adding another bar, the total number of Units that make of the total area, ideally as an overlay to the related bar (i.e. 4 in the example above).

If anyone has the answer, i would be grateful for your assistance.

Thanks