Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have a bar chart and I need the y-axis to cross the x-axis at 100 rather than zero. I cannot find an option for the cross point? Basically I need everything that is less than 100 to go to the left and everything greater than 100 to be on the right.
Thanks
Gareth
Hi,
Why dont you use the reference line for that.
Go to properties -> Presentation tab -> Reference line -> Add
Add the expression
Regards,
Kaushik Solanki
Hi Kaushik,
Unfortunately a reference line is simply an overlaid line. I need for the bar chart to actually run with a '0' being at 100 (i.e. just change the cross point of the x and y).
So rather than the following:
| xxxx
| xx
| xxxxxxx
| xxxxx
it would look like this:
| xx
xx |
| xxxxx
| xxx
Sorry for my bad drawing
Thanks
Gareth
hi,
John Witherspoon showed how to offset the x-axis in this post
http://community.qlik.com/message/111600#111600
maybe there is something in there for you
Hi,
I think its not possible to get y axis at value 100.
Regards,
Kaushik Solanki