Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 07-27-2016, 11:54 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to create time series plots with spans? Windows 7 64bit How to create time series plots with spans? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi
please post a sample sheet ( no pics please) showing your data and expected results. Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

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 05:59 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