13 Replies Latest reply: Sep 26, 2016 2:29 PM by Robson Candeo

# line chart order

Stupid question, but I never changed and not finding where can I invert the order of this line chart?

it is like this:

and I need inverted on y axes where 1 is on the top and 3 on the bottom

• ###### Re: line chart order

Like this?

• ###### Re: line chart order

yes, but I have negative values now. how to show only positives?

• ###### Re: line chart order

Number format, I got it. Thank You.

• ###### Re: line chart order

What's missing then?

• ###### Re: line chart order

You can use fabs or number format like (your format)

• ###### Re: line chart order

Hi Sunny,

Can you please explain the usage of dual function here, I know the standard behavior of dual i.e., for numeric representations for calculations on strings.

But this usage seems quite different and I don not seem to understand the logic here.

• ###### Re: line chart order

Still using the dual for the same thing. I am assigning each of the Value a negative notation, but for displaying purposes, I just want to continue showing the positive number. So here the text is just a actual non-negatived value. This helps me show the chart below 0 but it still continue to show positive number for the value on the axis. If I don't use dual you will see -1, -2, -3 on the axis instead of 1, 2, 3.

I am not sure how to explain this any better.

HTH

Best,

Sunny

• ###### Re: line chart order

Sorry, I was out last days. I have one graph that works, but other graph has negative values. I used format as number and this pattern: ###########,###;##########,###

• ###### Re: line chart order

###########,###;(##########,###)

• ###### Re: line chart order

What exactly is the issue? the axis?

• ###### Re: line chart order

yes, do you see the negative values at the left?

• ###### Re: line chart order

Those can be fixed by using a static step on the axis tab. Can you try adding a 1 there to see if the axis changes from negative values to positive values?

• ###### Re: line chart order

perfect, thank you