6 Replies Latest reply: Sep 10, 2012 3:16 AM by Adam Davies RSS

    plotting correlation line on scatter chart

    Adam Davies

      Hi All,

       

      I am a bit lost with this. I am simply trying to create a scatter chart showing the correlation between two expense types per dimension.

       

      E.g.

      Episodecost_acost_b
      11010
      22025
      3156

      Obviously creating the scatter chart is easy, however I can't seem to get the correlation line to show... I have tried using correl and rangecorrel but I think I must be using them incorrectly.

       

      I would be happy if I could plot this as a separate transparent chart over the top but I am a bit clueless as to how to achieve this!

       

      Example attached