Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-27-2016, 11:31 PM
DominionSoup DominionSoup is offline How to create time series plots with spans? Windows 7 64bit How to create time series plots with spans? Office 2013
Novice
How to create time series plots with spans?
 
Join Date: Jul 2016
Posts: 1
DominionSoup is on a distinguished road
Lightbulb How to create time series plots with spans?

So i am trying to create a time series plot that catalogues the number of items on each day over a span of time. For example, I have an operation that begins on 2/3/16 and ends on 4/5/16. I would like this operation to be counted in my time series plot every day between those two dates. In reality, I have like 600 of these time spans that I want on a time series plot (by week) where the operation is counted every day it is in use.



So let's say I have three spans: 2/3/16-4/5/16; 2/12/16-4/7/16; 2/27/16-5/2/16. If I were to look at my time series plot on the day on 2/4/16 it should show a quantity of one. If I were to look at it on 2/15/16 it should show a quantity of two. If I were to look at it on 3/18/16 it should show a quantity of three. If I were to look at it on 4/6/16 it would show a quantity of two. For any day/week I choose between these dates it should show me how many operations I have. How do I do this?
Reply With Quote
 

Tags
series, spans, time



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create time series plots with spans? Create hyperlink-able series Nathan8752 Word 6 11-09-2015 01:07 PM
How to create time series plots with spans? Create check box to insert current time dougdrex Excel 1 12-07-2014 07:52 PM
Trouble: Outlook File spans bad sectors - how to "tranfer" into other files? jwka Outlook 1 02-14-2014 12:52 PM
How to create time series plots with spans? How to create a formula using the IF in a time sheet. spaul Excel 3 10-28-2013 07:19 PM
Need to create a folder in Outlook AND on the Hardrive at the same time. cyanosaur Outlook 0 04-25-2012 07:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:27 AM.


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