Excel Graph help

[Isabella]

Hi, how can i reflect the below data on a graph that will show Months (Jan, Feb etc)

Excel Workbook
	A	B	C
5	Date	Cash	Securities
6	18-Mar-11	2003	620
7	25-Mar-11	1743	497
8	1-Apr-11	1578	539
9	8-Apr-11	2138	551
10	15-Apr-11	2324	471
11	21-Apr-11	1992	531
12	29-Apr-11	2089	593
13	6-May-11	1818	394
14	13-May-11	2838	422
15	20-May-11	1771	362
16	27-May-11	2594	425
HistoricalData

 

[GK039]

Add a helper column between Date and Cash with the following formula

=TEXT(A6,"mmmm")

and copy it down. It will give you the month name

Hope this helps you

George

Hi, how can i reflect the below data on a graph that will show Months (Jan, Feb etc)

Excel Workbook
	A	B	C
5	Date	Cash	Securities
6	18-Mar-11	2003	620
7	25-Mar-11	1743	497
8	1-Apr-11	1578	539
9	8-Apr-11	2138	551
10	15-Apr-11	2324	471
11	21-Apr-11	1992	531
12	29-Apr-11	2089	593
13	6-May-11	1818	394
14	13-May-11	2838	422
15	20-May-11	1771	362
16	27-May-11	2594	425
HistoricalData

 

[Isabella]

Add a helper column between Date and Cash with the following formula

=TEXT(A6,"mmmm")

and copy it down. It will give you the month name

Hope this helps you

George

Ok, i was hoping something could be done with the SERIES formula that will covert the dates to months?

 

[Donai]

ML 4***DELETE

 

[Isabella]

If i do that then the month will not be consolidated. How do i group the months? I dont want to use pivot charts cos i am using Excel 2003 and the refreshing is awful.

Excel Workbook
	A	B	C	D
5	Date	Date	Cash	Securities
6	18-Mar-11	March	2003	620
7	25-Mar-11	March	1743	497
8	1-Apr-11	April	1578	539
9	8-Apr-11	April	2138	551
10	15-Apr-11	April	2324	471
11	21-Apr-11	April	1992	531
12	29-Apr-11	April	2089	593
13	6-May-11	May	1818	394
14	13-May-11	May	2838	422
15	20-May-11	May	1771	362
16	27-May-11	May	2594	425
17
HistoricalData