1 Reply Latest reply: Oct 18, 2011 7:37 AM by Deepak Vadithala RSS

    Modify axis in bar chart?!

    Tobias Klinkenberg

      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?!
          Deepak Vadithala

          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