Charting Line Graphs Y-Axis in Reverse Order

Good Afternoon,

I have another question about if Alteryx has some same mechanism similar to Excel for graphs somewhere or any ideas on how I could do this?

Currently what the graph in alteryx looks like:

So I need to use a similar function in excel "values in reverse order" so that the Y axis is in reverse order like and the chart looks as follows:

Is there a tool in the configure chart I am missing to be able to do this or can anyone offer me some guidance on how to work toward reversing the Y axis?

Thank you in advance,

Nick

Data Investigation

Accepted answers

fmvizcaino

Hi @Faronnj ,

I'm not aware of a reverse axis in interactive chart tool. The only workaround I can think of is to multiply everything by -1.

Best,

Fernando Vizcaino

All comments

fmvizcaino

Hi @Faronnj ,

I'm not aware of a reverse axis in interactive chart tool. The only workaround I can think of is to multiply everything by -1.

Best,

Fernando Vizcaino

Faronnj

This will work until I can find a way to remove the negative signs before the values on the Y-axis. Thank you for your help today Fernando!

Nick

MariusMichael

Hi @Faronnj

You could also manually set the Display Range in your Axes-Option of the Interactive Chart and define a higher min than max.

When I define my custom range as Min: 7 and Max: 5, the x-axis ranges from 7 (left) to 5 (right) instead of the default ascending order.

This even works if then resetting to Automatic - reverse order will be stored nevertheless.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703