6 Replies Latest reply: Mar 9, 2015 9:22 PM by surfman joe RSS

    Sales comparison based on week #

    surfman joe

      I want to create a line chart shows sales comparison on last year and this year.

      the excel week column is formatted like "201401" that means year 2014 week 1.

       

      The easy part for me is to create line chart with week dimension. But I need

       

      1) show only 01, 02, 03 as week # on x-axis.

      2) show 2 lines in the chart, one for 2014 and the other for 2015.

       

      Can anyone give a hand? thanks in advance.