Analysis of trend between successful cases vs frequency (scatterplot)

[chandx]

Hi!
I'm not sure how to go about solving this - but I need to do an analysis using excel charts to assess if there is a trend between the performance of a list of managers handling their team of staff who are ranked either successful / unsuccessful vs the frequency of their attempts.


So my data table will look something like this:

Staff	Manager	Successful / Unsuccessful	Frequency
Staff 1	A	Successful	3
Staff 2	B	Unsuccessful	4
Staff 3	B	Successful	3
Staff 4	C	Successful	5
Staff 5	A	Unsuccessful	2
Staff 6	C	Successful	2
Staff 7	A	Unsuccessful	4

<tbody>
</tbody>

and so on...

Using the data table above, would like the end result to be something like a scatter plot where I'll be able to see the following:
- frequency / scatter of points within successful vs unsuccessful against the different frequency buckets
- individual team managers (A/B/C) to be separate series each with different colors for easier identification.

Can this be done? Or should I be using a different chart type instead?

Thanks!

 

[oldbrewer]

Staff	Manager	Successful / Unsuccessful	Frequency
Staff 1	A	Successful	3
Staff 2	B	Unsuccessful	4
Staff 3	B	Successful	3
Staff 4	C	Successful	5
Staff 5	A	Unsuccessful	2
Staff 6	C	Successful	2
Staff 7	A	Unsuccessful	4
					summary table
					manager	Successful	Unsuccessful	% successful
					A	3	6	33.3
					B	3	4	42.9
					C	7	0	100.0
					this table in effect ranks the managers

<colgroup><col span="2"><col><col><col span="2"><col><col><col><col span="2"></colgroup><tbody>
</tbody>