Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Possible to chart data for dates implicit within a range?
I have a list of computer programs with start and end dates for each. I need
to determine how many programs were running on my system on any given day. Can I get this data for individual days between the start and end dates without creating columns for each intermediate day? Ex.: Program 1 ran from 01/01/2005 to 01/14/2005. Program 2 ran from 01/06/2005 to 01/22/2005. Is it possible to chart the total number of programs running on 01/08/2005 without manually creating a column for that date? Thanks, Nechama |
#2
|
|||
|
|||
You can compute this with formulas. Star with data in A1:C4 as follows:
Start End Prog A 1/1/2005 1/14/2005 Prog B 1/6/2005 1/22/2005 Prog C 1/10/2005 1/20/2005 In E1 place the data in question (1/8/2005). In F1 enter this formula: =SUMPRODUCT((B2:B4<=E1)*(C2:C4=E1)) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Nechama wrote: I have a list of computer programs with start and end dates for each. I need to determine how many programs were running on my system on any given day. Can I get this data for individual days between the start and end dates without creating columns for each intermediate day? Ex.: Program 1 ran from 01/01/2005 to 01/14/2005. Program 2 ran from 01/06/2005 to 01/22/2005. Is it possible to chart the total number of programs running on 01/08/2005 without manually creating a column for that date? Thanks, Nechama |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Chart - Data Tables | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |