William Hulme
New Member
Hi all!
This is my first question so please be gentle if I seem a bit green, omit something or if I'm unclear in any area.
I am looking to create a scatter chart but nothing I do is working out anything close to what I am trying to achieve and I'm in need of help and guidance.
The purpose of the chart is to show people who and their ratings and tenure.
The data used would be:-
- A group of say 15 people
- A time period of 12 weeks
- A performance rating ranging from +100 to -100
Ideally what it would look like is as follows:-
- A scatter chart that is divided in to quartliles
- The quartiles would represent tenure over the 12 week period so top left could be
weeks 1-3, top right 4-6, bottom left 7-9 and bottom right 10-12
- The axis would run both vertical and horizontal through the centre. The centre point
would be a value of 100 and this would decrease in increments of say 20 until it
reaches the value of -100 at the outer part of the chart.
- The people being measured would then be the dots on the graph.
The chart produced would help me to identify people who need assistance as they would highlight as outliers with those not needing any help would bunch in the middle irrespective of tenure.
Is this at all possible and if so please could somebody provide me with some guidance as to how?
Many thanks for looking
Will
_________________________________________________________________
Post Moved by Moderator.
This is my first question so please be gentle if I seem a bit green, omit something or if I'm unclear in any area.
I am looking to create a scatter chart but nothing I do is working out anything close to what I am trying to achieve and I'm in need of help and guidance.
The purpose of the chart is to show people who and their ratings and tenure.
The data used would be:-
- A group of say 15 people
- A time period of 12 weeks
- A performance rating ranging from +100 to -100
Ideally what it would look like is as follows:-
- A scatter chart that is divided in to quartliles
- The quartiles would represent tenure over the 12 week period so top left could be
weeks 1-3, top right 4-6, bottom left 7-9 and bottom right 10-12
- The axis would run both vertical and horizontal through the centre. The centre point
would be a value of 100 and this would decrease in increments of say 20 until it
reaches the value of -100 at the outer part of the chart.
- The people being measured would then be the dots on the graph.
The chart produced would help me to identify people who need assistance as they would highlight as outliers with those not needing any help would bunch in the middle irrespective of tenure.
Is this at all possible and if so please could somebody provide me with some guidance as to how?
Many thanks for looking
Will
_________________________________________________________________
Post Moved by Moderator.
Last edited by a moderator: