trying to show totals on chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a list of dates, each with an associated category and time in minutes. Categories occur more than once in the list. I want to show the total minutes for each category on a bar chart, however I am only able to show each individual occurence, along with the time on my chart. Categories are on the x axis, minutes on the y

Can anyone help?
 
Tammy -

You could make a pivot table of the data. If the data is in three
columns (Date, Category, Duration), select the area and start the pivot
wizard from the Data menu. If you want a separate accounting by data and
category, put date in the row field, category in the column field, and
duration (sum of duration) in the data field. If you just want
cumulative values per category, leave out the date field, and put
category in the row field and sum of duration in the data field. Make a
pivot (or regular) chart from the resulting table.

- Jon
 
Back
Top