6 Replies Latest reply on Mar 1, 2011 2:47 PM by Bruno Vais

    Display total average price overlapped over seller price

    Bruno Vais

      Hi,

      I have a spreadsheet that looks like this (basically the price of 2 books solde by different sellers over 3 days)

       

      SKU        Seller    Price    Date

      Book1        A    $10    Jan 1 2011

      Book1        A    $12    Jan 2 2011

      Book1        A    $13    Jan 3 2011

      Book1        B    $17    Jan 1 2011

      Book1        B    $12    Jan 2 2011

      Book1        B    $11    Jan 3 2011

      Book2        A    $11    Jan 1 2011

      Book2        A    $13    Jan 2 2011

      Book2        A    $15    Jan 3 2011

      Book2        B    $12    Jan 1 2011

      Book2        B    $10    Jan 2 2011

      Book2        B    $9    Jan 3 2011

       

      I need to build a chart that displays the date as columns and the total price average line overlapping the seller averages.

      I know how to display the seller averages, but how can I overlap the total average on top of this?

       

      I attached my workbook, any help would be appreciated.

       

      thanks