Hi
I think I have created my spreadsheet incorrectly as I am trying to create a trend analysis comparing one financial year to the previous year, but also over a period of 12 months (hope that makes sense. I have tried the Insert Line Chart and that's having a fit
<tbody>
</tbody>
Person 1 January to February 2017 dipped in sales
Person 1 January 2017 compared with January 2018 was up
Its basically two sets of data a comparison to last year month/month, then over the year of 2017?
I am trying to build an overall view of sales against the sales person and how they are performaing month against month and then year against year, hope that makes sense
I think I have created my spreadsheet incorrectly as I am trying to create a trend analysis comparing one financial year to the previous year, but also over a period of 12 months (hope that makes sense. I have tried the Insert Line Chart and that's having a fit
Name | Jan 2017 | Jan 2018 | Feb 2017 | Feb 2018 |
Person 1 | £20,000 | £25,000 | £10,000 | £5,000 |
Person 2 | £85,000 | £15,000 | £87,000 | £25,000 |
Person 3 | £4,500 | £25,000 | £12,000 | £32,000 |
<tbody>
</tbody>
Person 1 January to February 2017 dipped in sales
Person 1 January 2017 compared with January 2018 was up
Its basically two sets of data a comparison to last year month/month, then over the year of 2017?
I am trying to build an overall view of sales against the sales person and how they are performaing month against month and then year against year, hope that makes sense