MS Excel Graph problem - TechRepublic
Question
May 27, 2008 at 05:42 AM
anders.wennerwik

MS Excel Graph problem

by anders.wennerwik . Updated 18 years, 2 months ago

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?

This discussion is locked

All Comments