Saturday, June 8, 2013

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   Jun 08, 2013
user Tarek Salama (!mydiscussions/docs/T8CTJIWcNOQ)
Expenses Sheet
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. 

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