![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time Remaining Progress Bar | teza2k06 | Excel | 1 | 05-13-2014 05:41 AM |
Time allotted minus time used with result in hour and minute | esther6086 | Excel | 2 | 04-29-2014 05:03 PM |
Average minus outliers? | markg2 | Excel | 2 | 01-07-2012 05:46 PM |
![]() |
jerryjaysr | Excel | 4 | 06-29-2006 07:27 AM |
Having your cake and graphing it to! | Ziegemon | Excel | 0 | 03-21-2006 01:24 PM |