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?
--
Thanks

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.

Thanks smartin, that's what I ended up doing, after realizing maybe it's not
possible.

on a seperate note, I am having a hard time searching my post. whenever I
post, I remember the subject, in this case, Graphs, but when I enter "Graphs"
in search for box, i don't see my post. I see other post, just not mine. I
was only able to find my post, clicking on excel, and leaving search for box
blank and then backtracking on the date I posted my question.
--
Thanks


"smartin" wrote:

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.
.