2 Replies Latest reply on Aug 7, 2013 4:10 PM by Jonathan Whiting

    How to make different marks on the same linegraph?

    Jonathan Whiting

      I am trying to create a line graph comparing speed to time. In an attempt to compare two speeds, a model output (orange) and the actual speeds (blue), I am creating two separate lines. The problem is that I need the blue line to have a mark type of "shape" and the orange line to have a mark type of "line".

      Compare Speeds.jpg

       

      The complication is with the way in which the data is organized. Here is an dummy example below (CSV):

      Minute,Speed,File

      0,10.00,Model

      10,10.00,Model

      20,11.00,Model

      30,11.00,Model

      40,10.00,Model

      50,10.00,Model

      14,10.14,Actual

      22,10.87,Actual

      23,10.35,Actual

       

      I would simply create a dual axis if it were instead listed something like: Time,Model Speed,Actual Speed. However, because of averages that are used in other workbooks, I cannot force the different speeds to align (if that makes sense). So keeping the data as it is organized, is there a way to change the mark type on the blue line?

       

      Thanks,

      -Jonathan

      (P.S. I apologize that I am unable to post the actual workbook due to proprietary data)