Hi all,
I'm looking for some actual data and projected data on a line graph.
What I currently have for actual data is -
| Revenue Period | % Submitted in 20days |
| 2016/05 | 54.6% |
| 2016/06 | 51.0% |
| 2016/07 | 48.9% |
| 2016/08 | 45.8% |
| 2016/09 | 49.0% |
| 2016/10 | 51.3% |
| 2016/11 | 64.1% |
| 2016/12 | 56.5% |
| 2017/01 | 59.5% |
| 2017/02 | 49.6% |
| 2017/03 | 58.1% |
| 2017/04 | 62.9% |
| 2017/05 | 61.2% |
| 2017/06 | 57.4% |
| 2017/07 |
| 2017/08 |
| 2017/09 |
| 2017/10 |
| 2017/11 |
| 2017/12 |
And I want to project 2017/07 onwards My boss has produced some in excel based on 2016/05 + 2017/06 - 2016/06 for 2016/07 and so on for 2016/08, 09, 10, 11, 12.
Any suggestions would be great
