Graph Data question

[Alisya]

Hi, i have a set of data which is inputted every week but i only need to plot graph by choosing the middle date and end date. What is the best method for me to do this? So as an example for Jan I choose 14/01/11 and 28/01/11.

Excel Workbook
	A	B	C
1	Date	Cash	Securities
2	7-Jan-11	2264	630
3	14-Jan-11	1443	513
4	21-Jan-11	1211	513
5	28-Jan-11	1911	504
6	4-Feb-11	2054	481
7	11-Feb-11	1456	536
8	18-Feb-11	1627	578
9	25-Feb-11	1571	630
10	4-Mar-11	1664	629
11	11-Mar-11	1622	687
12	18-Mar-11	2003	620
13	25-Mar-11	1743	497
14	1-Apr-11	1578	539
15	8-Apr-11	2138	551
16	15-Apr-11	2324	471
17	21-Apr-11	1992	531
18	29-Apr-11	2089	593
19	6-May-11	1818	394
20	13-May-11	2838	422
21	20-May-11	1771	362
22	27-May-11	2594	425
Sheet1

 

[Steve=True]

Here is a great example of what you are trying to do:
http://blog.contextures.com/archives/2009/05/03/select-excel-chart-dates-from-a-drop-down-list/

 

[Alisya]

Here is a great example of what you are trying to do:
http://blog.contextures.com/archives/2009/05/03/select-excel-chart-dates-from-a-drop-down-list/

That example assumes you have Excel 2007, how would you do that in 2003?

 

[Steve=True]

As she states in her tutorial,
Ignore this step: "Create an Excel Table for the Chart Data"

and it will work in 2003 as well.

 

[Alisya]

As she states in her tutorial,
Ignore this step: "Create an Excel Table for the Chart Data"

and it will work in 2003 as well.

But the data for the graph is what is in the drop down menu, my data will have dates which i don't want in the drop down menu, how do i go around this?