Pie Graph chart questions

[jfoley]

Ok, i am brand new to this forum but i would say i am intermediate with excel. Here is the problem. Lets say i have a spreadsheet like this...

______A_____________B__________________
1....MINUTES........ACTIVITY
2.........15...........driving
3.........30...........reading
4.........40...........eating
5.........10...........driving
6.........15...........reading

Lets say all cells in column B are dropdown boxes with selections.

What i am having a hard time figuring out is displaying a pie chart that will display the total amount of time spent on each activity. So, for the example, the pie chart should have a slice of driving that is equal to 25 minutes, a slice for reading which should equal 45 and a slice for eating which should equal 40. Appreciate the help!

[oldchippy]

Hi,

You need to total your times using something like SUMPRODUCT, may be using your "list" from your drop-down?