I’m trying to create a graph that shows both amount of revenue (Y) and staff (X) increases.
In my case A1:A5 contains name of company, B1:B5 revenue year 1, C1:C5 Amount of staff year 1,D1:D5 revenue year 2, E1:E5 Amount of staff year 2. What I want is for each row to show a starting point – finish point connected by a line. ie, Company A started on 100 staff and ?1000 revenue and finished on 150 staff and ?2000 revenue.
Any ideas on how and if I can achieve this in Excel?