Chart help - rainfall data

[BravoBravoAu]

Hey all - I have a five sheet workbook and need some assistance with charts to represent and understand monthly and yearly weather trends. There are too many variables for me to get this to work as I am hoping!

Sheet 1 - Rainfall data
This sheet contains rainfall data from 1995 (currently formatted to 2060) on a monthly basis.

Year		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	TOTAL
1995	Rainfall	81	37	18	90	58	152	153	63	66	69	52	49	888
	# of days	5	2	1	8	5	9	10	8	9	7	7	6	77
	# of frosts	0	0	0	0	1	10	12	13	4	1	0	0	41
1996	Rainfall	114	89	90	60	13	129	179	192	149	61	45	36	1157
	# of days	7	4	6	6	2	8	11	14	9	7	5	3	82
	# of frosts	0	0	0	1	2	6	7	12	9	2	0	0	39

A2:4, A5:7, A8:10 etc is merged for each year, as there are three rows of data for each year.
'Rainfall', '# of days' and '# of frosts' are input at the end of each month. Yet to be used months and years are presently blank.
Totals in column O are autosummed.

Sheet 2 - Rainfall charts
I want to generate two charts in this sheet:

• Comparative yearly total rainfall.
• Comparative monthly rainfall, with average (mean) data label.

Sheet 3 - Days rainfall charts
I want to generate two charts in this sheet:

• Comparative yearly (number of) rainy days.
• Comparative monthly (number of) rainy days, with average (mean) data label.

Sheet 4 - Frosts charts
I want to generate two charts in this sheet:

• Comparative yearly (number of) frosty mornings.
• Comparative monthly (number of) frosty mornings, with average (mean) data label.

Sheet 5 - Historical average
I want to generate historical yearly rainfall average (mean) in this sheet - or perhaps display this in Sheet 1, but I can't work out how.


Hopefully someone is able to spend a bit of time to help me out!! Thank you in advance.

 

[myall_blues]

If it's not too late I think you could benefit from rearranging your data. Then you can make your graphs directly from the data or from a summary table as required without the issue of having to deal with every third row, for example. The dates in column A are proper Excel dates, not text.

Book1
	A	B	C	D	E	F	G	H	I	J
10						Summary
11	Date	Rainfall	Rain days	Frost days		Year	Rainfall	Rain days	Frost days
12	Jan-95	81	5	0		1995	888	77.1	41
13	Feb-95	37	2	0		1996	1157	82	39
14	Mar-95	18	1.1	0
15	Apr-95	90	8	0
16	May-95	58	5	1
17	Jun-95	152	9	10
18	Jul-95	153	10	12
19	Aug-95	63	8	13
20	Sep-95	66	9	4
21	Oct-95	69	7	1
22	Nov-95	52	7	0
23	Dec-95	49	6	0
24	Jan-96	114	7	0
25	Feb-96	89	4	0
26	Mar-96	90	6	0
27	Apr-96	60	6	1
28	May-96	13	2	2
29	Jun-96	129	8	6
30	Jul-96	179	11	7
31	Aug-96	192	14	12
32	Sep-96	149	9	9
33	Oct-96	61	7	2
34	Nov-96	45	5	0
35	Dec-96	36	3	0
Sheet1

Cell Formulas
Range	Formula
G12:I13	G12	=SUMIFS(B$12:B$35,$A$12:$A$35,">="&DATE($F12,1,1),$A$12:$A$35,"<="&DATE($F12,12,31))

 

[JV0710]

Something like this ?