How do I flip the x axis on a vertical bar chart?

Takalla · June 27

I have a vertical bar chart that has a goal of 25. The user is confused because the goal is "anything under 25 is good" but with how the chart looks it looks like you are trying to reach 25 because the goal is set at the top of the card.

Is there a way to flip it so that the x axis is at the top of the card and thus makes it so the bars are coming from the top instead of the bottom?
This way the goal would be situated under the x axis not on top of it.

I want it to look like it would if I had negative numbers for my data (only the data is not negative numbers, I just want the layout the same).

MarkSnodgrass · June 27

You could create a beast mode that multiples your number by -1 and then put that beast mode in your x-axis. The numbers will display as negative, but it would give you the look you are going for. You could also hide the scales so that the negative numbers don't appear on the x-axis, which might help with the look.

ColemenWilson · June 27

Agree with what @MarkSnodgrass has said. I would add that you could use color rules that when the value is under 25 it is green and when it is above it is red, etc…

MarkSnodgrass · June 27

You could create a beast mode that multiples your number by -1 and then put that beast mode in your x-axis. The numbers will display as negative, but it would give you the look you are going for. You could also hide the scales so that the negative numbers don't appear on the x-axis, which might help with the look.

ColemenWilson · June 27

Agree with what @MarkSnodgrass has said. I would add that you could use color rules that when the value is under 25 it is green and when it is above it is red, etc…

Takalla · June 27

I ended up just making them negative numbers and then using the ($0.00) format since I have other cards on the same dashboard that are actually negative numbers and they're using the -$0.00 format.

The idea of using red and green is actually a very good one and I would've rather just used that to solve this but we're using our brand colors on the bar colors so unfortunately that isn't an option in this case.

Thank you both!

Picture of solution:

david_cunningham · June 28

One thing you could do is to use a tooltip and wrap your value inside ABS() in beast and then display that tooltip. That way the values you display will be positive, but the chart will still be inverted like you are looking for.

How do I flip the x axis on a vertical bar chart?

Best Answers

Answers

Categories