Stacked and 100% stacked column chart combined

[Anonymous]

Hello

I've asked this question previously but haven't gotten a response, so trying again. Is there a way to combine the two following visualisations into one 

to create something like this (below), where the height of the bars is determined by the values (as shown by the second visualisation above), whilst also displaying the NPS category breakdown. Ideally, if the score is negative, the bar should be inverted (or below the x-axis, as shown in visualisation 2 above), but the percentages should add to +100%

Any help would be appreciated

[Anonymous]

Thanks for the reply. Hopefully it'll be something that will be possible in the future (esp if it can be replicated in Excel already).

[v-cgao-msft · Accepted solution]

Hi @Anonymous ，

I did some tests and suspect that this is not yet possible.

This is the closest I could get, but the negative part of the stacked histogram is still above the x-axis.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data