Hi,
I am new to Excel (at least the automation part of it) and I would like to perform a very simple task. REcently I realized that I am spending time adding values to generate my monthly expense chart. I would like to automate that. The process would be as follows:
1) Go thru the "type" column and increment the total $ per type
2) Put that on in a pie chart

An example:
Type $ description
groceries 25.00 groceries addr
gas 15.00 that gas station
gas 5.00 the other gas station
fun 5.00 nightclub last sat
home 50.00 electricity bill
TOTAL 100.00
I would like to create a pie chart w/

groceries 25%
gas 20%
fun 5%
home 50%

I thought I could write some code to go thru the first column, locate the type, get in a case statement, add to the type total and when it reaches the end it would compute the percentage and finaly put it in the chart.

Does anyone have any hint for me to start? I can program though I have never done any VBA and I am not sure if it is necessary to write any code for this. Maybe there is some excel function for this purpose.

Thanks!