2 Replies Latest reply on Feb 8, 2018 2:33 PM by Joe Oppelt

    How to change Axis on parameter value?

    Ayushi Singh

      HI Team,

       

      I need to change axis on changing value of my parameter.Please help?

       

      As if its 1 ....axis shud be........ 0.5.10.15

      if its 2  ... axis shud be..... 1.10.20

      if its 3 ...axis shub be 0.50.100

       

      Thanks

      Ayushi

        • 1. Re: How to change Axis on parameter value?
          Chris McClellan

          You can't change the axis on a sheet like that.

           

          To solve this, you would create 3 sheets and do sheet swapping between the 3 of them

          • 2. Re: How to change Axis on parameter value?
            Joe Oppelt

            You can control axis ranges IF THE RANGE VALUES ARE BEYOND YOUR DATA VALUES.

             

            If you have data that runs from 5 through 10, you can add a reference line at 15, and your axis would extend to 15.


            But if you have data that runs from 5 through 10 and you add a reference line at 8, the axis will still go out to 10.

             

            Likewise you can extend the lower range of the axis from 5 down to 2, for example, using the same technique.  (Assuming you have turned off the check box to show zero.)

             

            So you can have 2 calcs that set high end and low end, and you can set the value of the calcs according to the value of the parameter -- again, assuming these end ranges are beyond the min and max of the data you expect to display on the chart.

             

            Actually, if you will have data beyond those ranges and you don't want to show extremes beyond those ranges, you could also set a filter to display only what falls between those ranges based on the value of the parameter.