In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Charting Line Graphs Y-Axis in Reverse Order

Faronnj
8 - Asteroid

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:

Faronnj_0-1578958012923.png

Faronnj_1-1578958036348.png

 

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:

Faronnj_2-1578958129465.png

 

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 

3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor

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
8 - Asteroid

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
5 - Atom

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.

Labels
Top Solution Authors