Converting daily data into monthly

Hello everyone. I have daily rainfall data and I want to convert it to monthly totals. Please can someone help? See the data attached and the format I want it to appear. Thanks.
Uvirkaa

excelforum2.xlsx

plz hit thanks

drag 'year' into column labels to get the month on the X axis

Hey Myslin. Thank you very much. Please can you explain to me step by step how you got to that level? Iam a beginner so you may need to give me the details. Thanks

Highlight all of your data including the headers

Insert > Pivot Table

now you have to define the areas for your chart.

I used years on the rows
put your pct in the values section selecting the function to SUM all values

Now you have to group by an appropriate time, right click on the rows where you see the years; select group; select years and months. Add years to column line and it will seperate by months in the columns! Hope this helps!

Originally Posted by oeldere

@akumagaavese

I get this pivot table.

See the attached file.

First I make an table of the data.

Excel 2007 => insert table.

After that I use formula's to determine the day, weekday, week, month, quartal, year

After that I made an pivot table of the data. (in the sheet Oeldere).

Excel 2007 => insert => pivot table.

I this example I used the year and month (as you asked) but it can also be show per week.

Do you have questions or comments on this item, just ask or comment.

There's no need to use a formula for determining weeks, months, etc as the pivot table will do it for you.

Please see attached
excelforum2.xlsx

@Myslin. This is perfect. I appreciate this help.Remain blessed