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.




      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