Bar chart after pivot- unexpected

[ankit123]

Hello, I have a look that is a bar chart, this look is supposed to show 3 values, lets call them A, B, and C, to get the results I want, I pivoted the data/results by value A, so now value C will have up to 3 different columns for values, when value C has at least 2 columns, the bar chart works the way I want it to work, but when value C only has 1 column, it doesnt work the same way anymore

so what is supposed to happen is, the y-axis should show value C, the x-axis should show value B, and the legend should be value A.

what i noticed happening was when value C only has 1 column in the results then the legend disappears and the y-axis name becomes value C while the actual values shown on the graph are of value C, but when value C has 2 or more columns, the legend comes back and everything goes back to normal.

the y-axis name is what its supposed to be, the values in the y-axis are correct

the values of the y-axis are still correct but the name of the y-axis is now the only value that should be in the legend

'Number of Work Orders' here has 2 columns, 1 for Medium Risk and one for Low Risk, the y-axis has the correct name and the legend shows that there are 2 different types of risks

[leobardor · Accepted solution]

Hi Ankit!

I created a similar test I got the same behavior.

I think you can customize the label name of this axis:

(For instance):

Hope it helps!

Best regards,

Leo

[ankit123]

Hi Ankit!

I created a similar test I got the same behavior.

I think you can customize the label name of this axis:

(For instance):

Hope it helps!

Best regards,

Leo

Hi Leo,

Thanks for giving time and answering my question. Actually in my chart,  the y-axis should show value C, the x-axis should show value B, and the legend should be value A and if I rename it how will it work ? Could you please help me over here ?

Thanks and regards,

Ankit