Apologies, I realised I was unclear with my question.
For the scatter plot, I would need couple of things
1. 24 Months trend (To show their sales for the past 24 months), from month 1 to 24.
- This will show the total sales per month up till 24 months for all sales person. (E.g) Salesperson A, Month 1 10k, Month 2, 20k and so on), however I would need to show for all, as I am intending to create a corelation at a later stage using this result.
2. I also would like to plot my own average line which should be showing an upwards trend as that is the benchmark that I would want to see the sales person growth vs my predetermine sales person.
The 24 months that I meant from the day that the sales person joined. It doesn't matter to me when do they join, what matters is when did they made the sales. So if a sales person had their first sales in his 3rd month, a dot will appear on the 3rd month.
Something like my graph here, I sort of managed to get the data to show for 24 months, however, I have yet to check for issues. As for the white line, it should be an average line that is preset by me, whereby i will be able to identify which sales person is performing below average and it needs to be as per what I drawn a growing line.