Forum Discussion
How to create a horizontally stacked pyramid chart
How can I create a horizontally stacked pyramid chart like this:
You can see the left chart has an inverted x-axis range, while the right chart is it normal (increasing to the right).
It is based on a small multiple and having one of the charts have x-axis 'invert range'.
However it doesn't seem I can invert the range for the small multiples independently - or is there a trick to doing it?
Having small multiples means the y-axis labels are always aligned, even with missing data - so the option of using multiple
charts to do this is not a happy approach (I'm using it now while looking for a better solution)
I'm new to Deneb - making a custom visualisation - however I can't seem to get that to work for having the y-axis labels aligned
when there is missing data, so if you can make this work, that would be great, I'm flexible to the solution.
Hi costing
It's possible that the functionality is missing in the trial version and you need to make a purchase.
I'm not an expert on such graphs because they are problematic for users to read. I'm also attaching links to two articles on the problems with both tornado and stacked graphs.
https://www.madeiradata.com/post/home-experiments-and-stacked-bar-graphs
In any case, if you are still interested in using this, you can contact the pbivizedit' support directly via email:
[email protected]If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
3 Replies
- Ritaf1983
Super User
Hi costing
We don't have this kind of graph as a free option.
You can use a tornado chart of PbiVizEdit.
The link to download :https://pbivizedit.com/gallery/tornado
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Ritaf1983 I've tried what you suggested, however I'm not able to control the colours by the legend, is this possible? (It seems to be based on the link you sent me).
Here is the image from your link:
It seems 'Value A' represents the left side stacks. I'm hoping the legend would be independent of the value column.
Here's the data I'm using:category sex age1 age2 year y_val a m 1 5 2024 alpha a f 2 6 2024 alpha b m 3 3 2024 alpha b f 4 4 2024 alpha c m 5 2 2024 alpha c f 6 4 2024 alpha a m 4 6 2025 beta a f 5 2 2025 beta b m 6 1 2025 beta b f 3 2 2025 beta c m 4 3 2025 beta c f 2 4 2025 beta a m 4 5 2026 gamma b m 6 6 2026 gamma c f 2 4 2026 gamma
I noticed there needs to be two columns for the values, left and right. I can work around this, although I'd prefer to have just one value column and left/right be distinguished by a binary valued column, e.g. sex in the above example.- Ritaf1983
Hi costing
It's possible that the functionality is missing in the trial version and you need to make a purchase.
I'm not an expert on such graphs because they are problematic for users to read. I'm also attaching links to two articles on the problems with both tornado and stacked graphs.
https://www.madeiradata.com/post/home-experiments-and-stacked-bar-graphs
In any case, if you are still interested in using this, you can contact the pbivizedit' support directly via email:
[email protected]If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
