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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Staff[/TD]
[TD]Manager[/TD]
[TD]Successful / Unsuccessful[/TD]
[TD]Frequency[/TD]
[/TR]
[TR]
[TD]Staff 1[/TD]
[TD]A[/TD]
[TD]Successful[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Staff 2[/TD]
[TD]B[/TD]
[TD]Unsuccessful[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Staff 3[/TD]
[TD]B[/TD]
[TD]Successful[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Staff 4[/TD]
[TD]C[/TD]
[TD]Successful[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Staff 5[/TD]
[TD]A[/TD]
[TD]Unsuccessful[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Staff 6[/TD]
[TD]C[/TD]
[TD]Successful[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Staff 7[/TD]
[TD]A[/TD]
[TD]Unsuccessful[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
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!
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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Staff[/TD]
[TD]Manager[/TD]
[TD]Successful / Unsuccessful[/TD]
[TD]Frequency[/TD]
[/TR]
[TR]
[TD]Staff 1[/TD]
[TD]A[/TD]
[TD]Successful[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Staff 2[/TD]
[TD]B[/TD]
[TD]Unsuccessful[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Staff 3[/TD]
[TD]B[/TD]
[TD]Successful[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Staff 4[/TD]
[TD]C[/TD]
[TD]Successful[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Staff 5[/TD]
[TD]A[/TD]
[TD]Unsuccessful[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Staff 6[/TD]
[TD]C[/TD]
[TD]Successful[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Staff 7[/TD]
[TD]A[/TD]
[TD]Unsuccessful[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
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!
