Modify axis in bar chart?!

Tue, 18 Oct 2011 08:34:26 GMT

Hi,

I want to know, if it is possible to modify an axis in an bar chart?

The problem is:

I´ve one dimension and two formulars, which have to be designed like the example. I´ve multiply the blue bars by -1 to get this design.

The problem is that I´ve negativ numbers on the x-axis, which are positiv in fact... In a table I could solve the Problem with the following numer format:

#.##0;#.##0;0

But it doesn´t work in a chart axis.

Have anyone an idea?

Thanks in advance

Re: Modify axis in bar chart?!

IAMDV — Tue, 18 Oct 2011 11:37:10 GMT

Hi,

I had exactly same issue in the past. I could not change the negative Axes value to positive and still show on the left hand side. Fabs or multiplying by -1 will not work because it changes the display to the right. So I had to hide the Axes and show the Grid. Then I have used the TextBox to show the positive numbers. It is important to uncheck the position Allow Move/Size and also make your Axes range with Static Min and Static Max.

This is not 100% solution for your issue. But a workaround to get it working.

Good luck!

Cheers - DV

topic Modify axis in bar chart?! in QlikView

Modify axis in bar chart?!

Re: Modify axis in bar chart?!