Charting Line Graphs Y-Axis in Reverse Order

[Faronnj]

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 

[fmvizcaino · Accepted solution]

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.