Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
Like this?
yes, but I have negative values now. how to show only positives?
Number format, I got it. Thank You.
You can use fabs or number format like (your format)
If your question is answered please put sunny answer as correct answer and close this thread
What's missing then?
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.
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
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: ###########,###;##########,###
How about this format
###########,###;(##########,###)