Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Generating time based series
I have data in the following structure
Store Name Scheduled Opening Rescheduled Opening Actual Opening Redbank 11/03/2006 9/03/2006 9/03/2006 Tweed Heads 6/03/2006 15/03/2006 15/03/2006 Macarthur Square 14/03/2006 15/03/2006 15/03/2006 Whitsundays 5/04/2006 1/04/2006 1/04/2006 Lake Haven 8/04/2006 6/04/2006 6/04/2006 Pakenham 17/05/2006 16/05/2006 16/05/2006 Hervey Bay (Urangan) 21/06/2006 17/06/2006 17/06/2006 Ararat 30/06/2006 30/06/2006 30/06/2006 Highpoint 3/07/2006 30/06/2006 30/06/2006 Townsville (Willows) 9/07/2006 10/07/2006 10/07/2006 Beaudesert 26/07/2006 27/07/2006 27/07/2006 Salamander Bay 9/08/2006 10/08/2006 10/08/2006 Newmarket 19/08/2006 17/08/2006 17/08/2006 Smithfield 26/08/2006 23/08/2006 23/08/2006 Mudgee 31/08/2006 19/08/2006 19/08/2006 Carindale 23/09/2006 23/09/2006 Bellerive (Eastland) 24/09/2006 20/09/2006 Bankstown 28/09/2006 30/09/2006 and would like to have a chart that plots (on a progressive basis) the number of stores planned to open as one line, revised planned to open on a second line and then progressive actually opened on a third line. Where I am having difficulty is grouping the data - what I would like to display is the equivalent of a S-curve which would start at one store open on 11/3/06 and growing to over 100 stores being open by 1/7/07. Any suggestions, please? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Generating time based series
Hi Pete,
Suggest you orgainse the data to get a cumulative total of store opening by date, then use an x-y chart. A good way to get cumulative totals is to use a pivot table. That way it is also easy to group dates by month/quarter/year if you need to later. I have placed a sample of how to organise the data and build the chart at http://www.edferrero.com/CumulativeChartingSample.zip Ed Ferrero Microsoft Excel MVP http://www.edferrero.com "Pete" wrote in message ... I have data in the following structure Store Name Scheduled Opening Rescheduled Opening Actual Opening Redbank 11/03/2006 9/03/2006 9/03/2006 Tweed Heads 6/03/2006 15/03/2006 15/03/2006 Macarthur Square 14/03/2006 15/03/2006 15/03/2006 Whitsundays 5/04/2006 1/04/2006 1/04/2006 Lake Haven 8/04/2006 6/04/2006 6/04/2006 Pakenham 17/05/2006 16/05/2006 16/05/2006 Hervey Bay (Urangan) 21/06/2006 17/06/2006 17/06/2006 Ararat 30/06/2006 30/06/2006 30/06/2006 Highpoint 3/07/2006 30/06/2006 30/06/2006 Townsville (Willows) 9/07/2006 10/07/2006 10/07/2006 Beaudesert 26/07/2006 27/07/2006 27/07/2006 Salamander Bay 9/08/2006 10/08/2006 10/08/2006 Newmarket 19/08/2006 17/08/2006 17/08/2006 Smithfield 26/08/2006 23/08/2006 23/08/2006 Mudgee 31/08/2006 19/08/2006 19/08/2006 Carindale 23/09/2006 23/09/2006 Bellerive (Eastland) 24/09/2006 20/09/2006 Bankstown 28/09/2006 30/09/2006 and would like to have a chart that plots (on a progressive basis) the number of stores planned to open as one line, revised planned to open on a second line and then progressive actually opened on a third line. Where I am having difficulty is grouping the data - what I would like to display is the equivalent of a S-curve which would start at one store open on 11/3/06 and growing to over 100 stores being open by 1/7/07. Any suggestions, please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Predicting a Number From a Time Series | Excel Worksheet Functions | |||
Chart series (based on datarange content) | Charts and Charting in Excel | |||
How do I extract the month end value from a daily time series? | Excel Discussion (Misc queries) | |||
Run macro based on time | Excel Worksheet Functions | |||
How to exclude weekends/holidays from plotted time series | Charts and Charting in Excel |