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!
Hi,
You need to total your times using something like SUMPRODUCT, may be using your "list" from your drop-down?
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks