Excel graph layout

[Jemma Atkinson]

Hi, i want to create two graphs, one graph will take look at the last data set in each month and the other graph will take two data sets in each month, so middle and end date. I'm not sure how to get the graph to look at one data source but split into the above criteria

Excel Workbook
	A	B	C
1	Date	Cash	Cash No Comm
2	7-Jan-11	2264	0
3	14-Jan-11	1443	0
4	21-Jan-11	1211	0
5	28-Jan-11	1911	0
6	4-Feb-11	2054	0
7	11-Feb-11	1456	0
8	18-Feb-11	1627	0
9	25-Feb-11	1571	0
10	4-Mar-11	1664	0
11	11-Mar-11	1622	0
12	18-Mar-11	2003	1376
13	25-Mar-11	1743	1174
14	1-Apr-11	1578	1097
15	8-Apr-11	2138	1563
16	15-Apr-11	2324	1728
17	21-Apr-11	1992	1515
18	29-Apr-11	2089	1521
19	6-May-11	1818	1318
20	13-May-11	2838	2072
21	20-May-11	1771	1221
22	27-May-11	2594	2095
Sheet1

 

[Steve=True]

What do you mean by last data set?

Does last data set = may 27

and Middle and last data sete = May 20 and May 27

?

 

[RomulusMilea]

Hi Jemma,

Please create and post a very simple example of the graph, for each graph you need to have, linked to the list you posted. This will help us to help you.

On the other hand, please define "middle date" and "end date", with examples from the list you posted. Thank you.

 

[Jemma Atkinson]

What do you mean by last data set?

Does last data set = may 27

and Middle and last data sete = May 20 and May 27

?

Steve, last data for each month, so for may this would be 27th. The two fortnightly would be for example 13/05 and 27/05