Chart Creation for Funds Spent by Month

[kwright90]

Greetings Friends,

I need help creating this chart for my superiors. I have attached a sample spreadsheet that includes some random information. What I need to show is how much funds are spent on each catagory by month. I will need it on a line graph. In the spreadsheet I have included a sample format of what I am needing. If someone could please help me with this I would be greatful.

[mrice]

Hopefully the attached workbook is some use. It uses functions to take the invoice date and assign it to a month/year and then this is plotted out as a pivot chart. It's currently configured for 1000 rows of data.