Extracting data for month-by-month graph

Hi all,

Got really helpful tip earlier when I was having alot of trouble trying to fix my date format. I was hoping to ask for a little more advice

This is how I have my data at the moment. Basically I have a record of everytime a purchase was recorded, time and date.

I want to show the data on line graph with purchases per day as the Y-axis and months of 2012 as the X-axis. Apologies if this is a stupid question - I can't wrap my head around how to exact the data I have (B) onto a graph.

Any guidance would be really appreciated


Cheers,

Joseph

Thank you very much for the reply, apologies I didn't put up a sample workbook, it's 4.30am here so can't take it in at the moment, will have a good look through it when I get up

Thanks again, Joseph

Thanks, just had a look through it now.

Am getting a bit stumbled. I put in my date data in form dd/mm/yyyy and have tried to get the table to accept the new data to no avail. I do not need the time of purchase data, but deleting that seems to mess with the table too.

I've attached the book as I have it now, would be fantastic if you could have a quick look:

Test111111

So I had tried that, changing the data source to all of my data but it seemed to completely mess up the table and graph.

What I need the table to do is: go through the column A with all my date data (in format: 12/06/12 dd/mm/yyyy) then categorize it into months (e.g. 140 transactions in July) then graph that on a line graph with Purchases on the Y axis and Months on the X axis. The sample data Marvin gave me above did that exactly (although it has TimeOfPurchase which I don't need and seems to affect the table/graph) but I can't seem to input my own data into it.

Oh wow, yes that is exactly it!

How did you add the new data, did you have to manually add the months under Row Labels and then tell it to calculate how many there were, I need to do more books like this / add on to this - how would I go about doing that?

Sorry for the barrage of questions

You're a massive help

The TimeOfPurchase was added by Marvin above (fake data) I do not need Time, just the dates totaled and graphed month by month - hope that makes sense?