1 Reply Latest reply on Jun 1, 2016 1:36 PM by Joe Oppelt

    Compare Yoy

    Esteban Mann

      I have a data base like this:

       

      DATEUSD
      feb-1510
      mar-155
      abr-152
      may-155
      jun-156
      jul-152
      ago-152
      sep-155
      oct-1554
      nov-156
      dic-152
      ene-166
      feb-167
      mar-164
      abr-163
      may-166
      jun-163
      jul-166
      ago-167
      sep-163
      oct-16678
      nov-168
      dic-166

       

       

      I want to make a graph USD vs month with two lines, one for 2015 and other for 2016, I want to compare 2015 vs 2016. How can I do it?

      Thanks and sorry for my English

        • 1. Re: Compare Yoy
          Joe Oppelt

          I would start off by making real dates. 


          If I try to pop that into excel, it does all sorts of weird things to some of those dates.  Consider spelling out the year:  2015, 2016, instead of just 2-digit years.  Or put it in a format like mm/dd/yy.  (Just use 01 for day.)

           

          Otherwise consider having two columns, [month] and [year].  Just integers.

           

          What you want to do is run months along the x-axis.  Whether it is an integer value or a date value doesn't matter.

           

          Do SUM([USD]) for your lines, and then put [YEAR] on the color shelf.  You'll get a line for each year that way.

          1 of 1 people found this helpful