3 Replies Latest reply on Feb 7, 2012 1:45 PM by Shawn Wallwork

    Showing % Difference on Dual Axis

      Hey all...

       

      I am trying to show the rolling 12 mo sales bar chart, along with % difference line chart on a dual axis. As sales fluctuate month to month, these can be both positive or negative changes.

       

      I want to be able to show it like the attached image. However, I am not able to change the Y axis origin (-5% in the image). It is always 0. I have attached a workbook example of what I have gotten to so far and I have ran out of ideas.

       

      I feel like it should be a somewhat simple thing to do, I am just oblivious to it.

       

      % growth.PNG