My Bar Chart Category Text is not aligned

[cswshaun]

Hi All,

I need abit of help. I want the bars to appear in different colors as shown in the bottom graphic (thats why i made use of the legend to help with the coloring) but the category text below the bars (position1,2,3 etc.) are not aligned to the bottom of the bars (top pic is my desired outcome but i need the colors on the bars) Is there a way to resolve this? Thanks!

[Anonymous · Accepted solution]

Hi @cswshaun ,

According to your statment, I think you are using clustered column chart. On my side, I can reproduce your issue.

I think this is caused by the visual you are using. Due to you are using clsutered column chart, when you add [Position] into Legend field, visual support multiple legend for each X axis category.

Fx: In this visual, for Position1 Xaixs, there will be three legend data in it, however there is only Position1 has data, so it will show column in left. For Position2 Xaixs, there will be three legend data in it as well, however there is only Position2 has data, so it will show column in middle and so on.

Here I suggest you to try Stack column chart to achieve your goal.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@cswshaun , try to change, the inner padding, Minium category width or max are height