1 Reply Latest reply on May 15, 2018 6:56 AM by Simon Runc

    Y axis control Manually

    venkat venkat

      Hi,

       

      I want to control the y-axis manually. Can we do that?

       

      I'm attaching the workbook which I did it by sheet swapping. I want Y-axis control by a slider or reference line or by a parameter. That means I want it in a single sheet.

       

      Please let me know if you don't understand.

       

      Thanks,

      Venkat.

        • 1. Re: Y axis control Manually
          Simon Runc

          hi Venkat,

           

          Here you go...

           

          So first thing was to change your Axis Control Parameter to a Float (you can still use the Alias if you want a more human readable name)

           

          Then I changed the mark type to Gantt. First thing was to not plot any values that won't be shown

          [Profit Gantt]

          IF [Profit TC] > [Y axis atarts from]

          THEN [Profit TC]

          END

           

          where [Profit TC] is just you %of Profit TC as a named formula

           

          Next we need to only draw the Gantt back to our selected Axis...

          [Gantt Size]

          IF [Profit TC] > [Y axis atarts from]

          THEN([Profit TC]- [Y axis atarts from])*-1

          END

           

          and then we bring this all onto the chart and set the Axis to 'Not Include Zero'...and we have the controllable Axis.

           

          Hope that helps and makes sense