Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'd like to have a "normal" scatter chart, but with two little diferences.
1. The x axis should be on top
2. The scale should be on reverse, ie, from 100% to 0%
The Y axis is the normal one.
Does anyone knows how to do it?
Thanks in advance.
João
Hi João, if I remember correctly, you could check Static Min and Static Max boxes on the Axes tab in object properties in the Scale section for X axis and enter 100 for Static Min and 0 for Static Max. Another approach would be to reverse it in expression for example:
=if([X_COORDINATE]>0,Sum (100-[X_COORDINATE]),"")
Let me know whether it worked.
Sorry Mark, but it doesn't work.
this is what happens
With your sugestion, the x-axis scale became: 0,0 0,1 0,2 0,3 ... 1,0
What I want is: 100 67 33 0
And if it's possible to be on top of the chart was excellent.
The other solution you gave for the expression don't have no impact on the x scale
Hi Jpereir,
Any luck on this? I am also struck up in a similar problem. Appreciate your help.
Thanks & Regards,
Raajesh N