5 Replies Latest reply on Feb 3, 2013 3:15 AM by Andrew Marritt

    Difference of change from average change

    Andrew Marritt

      I have created a graph of difference change from starting time for a series of groups (so every one starts at zero at time=0)

       

      Using a double axis chart I've shown the average change for all groups.

       

      What I'd like to do is show for each group the change - the average change for all groups at that time period.

       

      So on the first sheet the fastest growing group has an 83% change on their starting position over the duration.  The average across groups is 14% change so I'd like to show the fastest group as 69% above the average growth.