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?

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" <Pete@discussions.microsoft.com> wrote in message
news:02B9F1F1-8DFA-4DB9-8B39-1F106A9A38B1@microsoft.com...
>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?