2 Replies Latest reply on Jul 10, 2016 4:44 AM by Syed Zafar Naqvi

    Creating a Scatter Plot when there is a restriction on source data (re)formatting

    Syed Zafar Naqvi

      Hi, I have my source data in the following format:

         

      Measure DateInstrumentValue
      7/1/2016A10.68429332
      7/1/2016B6.778200298
      7/2/2016A17.88322859
      7/2/2016B0.175028843
      7/3/2016A24.91837838
      7/3/2016B21.78254295
      7/4/2016A4.538417106
      7/4/2016B9.759935124
      7/5/2016A6.284015003
      7/5/2016B16.47808964
      7/6/2016A16.5504749
      7/6/2016B4.753530046

       

       

      I want to create a scatter plot with Marks showing a combined X,Y value against each date.

      I cannot pivot the source data, I believe that somehow I will have to recreate a pivot-like functionality against each row using formulas. Would appreciate any help!

       

      (packaged workbook attached)