Forum Discussion
2 level y axis
It may be that I miss something very obvious. Sorry, I am new and struggling...
My data table:
I would like to obtain a graph which looks like this one made in Tableau (note 2 clearly separated columns on the left):
The closest I could get was the graph below. But for levels with longer labels, concatenating labels like this looks too much of a clutter. I would love to find a way to separate levels into 2 nice columns like in the graph above.
4 Replies
Zyg_D you can use matrix visual and use bar chart for amount in conditional formatting.
parry2k- thank you for the reply. The result looks like this:
This may help in some cases, even using the example that I posted. But it has unnecessary totals/ subtotals and in doesn't explicitly show another column with its respective title. Also, it cannot show the x axis with labels. It seems to be rather a workaround than a solution. In this way, I cannot change the type of the graph to e.g. stacked 100% bar chart. This is what I originally was expecting to receive, while the given example is oversimplified, my apologies. In Tableau it is possible to get stacked bar chart together with 2 columns of categories. Would you have any suggestion if I wanted a stacked 100% bar chart?
