Forum Discussion
Correlation Chart
I have been asked to create 3 x correlation charts:
1. To show the relationship between time spent in a role and their mental health score
2. To show the relationship between their exposure to fatalities and 3 mental health scores
3. To show the relationship between their exposure to fatalities in and out of the workplace and 3 mental health scores
I have read multiple forums on correlation charts but I can't work it out. I have attached the document with the 3 sets of data, if someone is able to share how I go about this, or even if a correlation chart is the best format to show this anaysis.
Using Excel for Mac Version 16.53
Thank you!
1 Reply
charliekidd I added a few Scatter charts on the basis of your data. Would that be what you need?
To insert a such a chart, choose the data range for X and Y. On the Insert ribbon, select the Scatter chart icon.
