Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 168
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, 10 views)
Reply With Quote
 



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
Having your cake and graphing it to! Ziegemon Excel 0 03-21-2006 01:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft