I'm trying to create a scatterplot in Excel and am struggling to get it formatted correctly.
I have a lot of employees that have three metrics that are used to measure them. I'd like to create a scatterplot that uses two of these metrics to determine where their 'dot' goes, and use the third metric to determine formatting for that point (color differences based on their result). This would help me identify outliers across the board.
I'm struggling to do a few things:
1) How do I add the additional axis' that stretch across the chart at the median values? (The giant + in the middle of the chart that break it into quadrants)
2) How do I (or can I) format the dots on the chart based on a third value?
3) How do I attach a name to each data point so I can hover over the dot and see the employee it represents? Without having to manually do it?
Thank you!!
Bookmarks