Graphing plus/minus progress against time
I am not too hot with Excel- basics and some advance functions, but dont use graphing a lot so am getting stuck here.
my data set consists of date (over about a 4 week period), target work (the amount of work that needs to be done), and actual work (the amount of work that was done). I have created a bar graph to to show target/actual progress against time, relatively simple, but I also need to show a difference graph and no idea where to go.
I want time as the x axis, with the difference between target and actual work on the Y. So if we needed to achieve 30 work units and achieved 25, the plot would be -5 against date. I have the column for difference in work, so its just a 2 column graph, but I can tfigure out how to make it.
I have attached a sample sheet to give an idea of the type of graph and data, any help would be most useful.
|