yogi_From Form Data Extract And Chart Expense Type And Amount For Specified Month

                                          Google Spreadsheet   Post  #1229
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 08, 2013
user Tarek Salama (http://productforums.google.com/forum/?zx=48ig6ztrq4va#!mydiscussions/docs/T8CTJIWcNOQ)
Expenses Sheet
Hello,

I created a form that allows me to enter my expenses and the expenses type and then it throws the data into a spread sheet. In that sheet, I have a column for the date and time when the data was recorded, and a column for the expenses type, and a column for expenses amount.

Now, I would like to - automatically - make a pie chart that draws the expenses types versus the expenses amounts. And I would like the pie chart to be drawn for each month. I would like it to be as automatic as possible. I guess I'll have to create a sheet manually for each month? I don't know really as I'm no expert in spread sheets.

Any help is appreciated. 

---

https://docs.google.com/spreadsheet/ccc?key=0AiKFSrkwQVWkdEhCUWhBMjRIQjMxN1pfMmFKTDQwWnc&usp=sharing

https://docs.google.com/forms/d/1AjUoErSQCADBEHB1Sa9w3ru9v6o1PR7dYXEiJR1rN3M/edit?usp=sharing

Here's what I've done so far. Thanks for any help :)

----------------------------------------------------------------------------------------------------------------------