![]() |
|
#1
|
|||
|
|||
![]()
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? |
#2
|
||||
|
||||
![]()
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 |
![]() |
Tags |
series, spans, time |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Nathan8752 | Word | 6 | 11-09-2015 01:07 PM |
![]() |
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 |
![]() |
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 |