6 Replies Latest reply on Feb 7, 2012 2:21 PM by dariuskilstein

    Conditional axis based on chosen data

      Hi Guys,

       

      I've got a pretty simple question that doesn't seem to be simple to answer.

       

      I've attached 2 screenshots as I cannot upload the workbook

       


      Basically, I have a parameter that controls which data gets displayed on the graph. There are two options:

       

      1) YoY Visits

      2) Visits

       

      When YoY Visits is selected, i want the axis to be a %

      When Visits is selected, I want the axis to be a full number.

       

      However it seems that the axis can only have one format type (number OR percentage).

       

      Is there a way to conditionally control this axis?

       

      Thanks in advance,

      Darius