Hi everyone, happy to be joining this community.
I have looked everywhere for a solution for this, perhaps I'm not asking the question correctly - apologies if this has been asked before and I'm simply unable to google it right!
I'm trying to map the numbers in two columns to one single point on a scatter graph to have one single point visualization of the size of different teams in my company and their success rates across their goals. Currently, the best I'm able to do is to have one point for each column (i.e a point for Team A Number of members and another for Team A Success Rate). What I'm trying to achieve is probably best explained in the attached file. I drew the result I'm aiming for in Paint and added to the file.
I've tried editing the axis, re-selecting the data in a number of different ways but to no avail.
Thank you very much for any help with this!
Bookmarks