Thread: Graphs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Graphs

user wrote:
Hello

I am trying to create a bar/line graph.
I have 2 columns, 1st with names and 2nd with hours. My problem is that
some names appear multiple times, in those case, I want the name to appear
only once on the graph, but to sum the hours. Is this possible and how?


Line and bar graphs treat each item in the list as a new category; they
are not smart enough to unduplicate the list.

So, create a separate range with distinct names in one column and a
SUMIF formula in the next column to summarize the results, and base the
graph on the new range.