Microsoft Office Forums Graphing plus/minus progress against time

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2014, 03:30 AM
Guloluseus Guloluseus is offline Graphing plus/minus progress against time Windows 7 64bit Graphing plus/minus progress against time Office 2010 32bit
Competent Performer
Graphing plus/minus progress against time
 
Join Date: Mar 2013
Posts: 160
Guloluseus is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Sample.xlsx (10.0 KB, 2 views)
Reply With Quote
  #2  
Old 09-02-2014, 10:57 AM
gebobs gebobs is offline Graphing plus/minus progress against time Windows 7 64bit Graphing plus/minus progress against time Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I've attached a few examples. I'm not sure why you had difficulty doing this if you were able to graph Target vs. Time.

In the first, the difference (Target - Actual) is displayed as a bar graph. However, since there are negative values, they overlay the horizontal axis and its labels.

In the second, this is helped somewhat by moving where horizontal axis crosses the vertical axis to -4. While the labels are no longer obscured by the bars, it is now a bit counterintuitive with "positive" bars representing some negative data.

Lastly, I changed the above to a line graph. Again, the labels are not obscured but in this the representation of negative data is less counterintuitive.

If you want to put them all on the same chart, it can be done by using a secondary axis.
Attached Files
File Type: xlsx Sample.xlsx (16.5 KB, 3 views)
Reply With Quote
  #3  
Old 09-03-2014, 03:21 AM
Guloluseus Guloluseus is offline Graphing plus/minus progress against time Windows 7 64bit Graphing plus/minus progress against time Office 2010 32bit
Competent Performer
Graphing plus/minus progress against time
 
Join Date: Mar 2013
Posts: 160
Guloluseus is on a distinguished road
Default

Cheers Gebobs- exactly what I needed. I think I got stuck on the axis, mine were coming out the other way round (graph was vertical not horizontal) and it didnt even occur to me that I could change it. I dont use graphs too often, and this is only a client request to track daily outputs to prove we can achieve a completion date. Saved my bacon, thanks
Reply With Quote
  #4  
Old 09-03-2014, 04:39 AM
gebobs gebobs is offline Graphing plus/minus progress against time Windows 7 64bit Graphing plus/minus progress against time Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Mmmmm...bacon
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
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
Graphing plus/minus progress against time Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM
Graphing plus/minus progress against time Having your cake and graphing it to! Ziegemon Excel 0 03-21-2006 01:24 PM


All times are GMT -7. The time now is 04:30 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft