How to make bar graph

I have attached a spreadsheet as an example. I am trying to figure out how to put my data on a bar graph. I know how to do when its a more simple one. But take a look at this one. Basically I have multiple donors. There are three levels of donation, Gold, Silver and Bronze. They donate money each race. How do i put this data on one bar graph? I also want to make sure the donors are the same color throughout the whole thing. Any ideas? Does this make sense?
Line-Graph-Example.xlsx
brasimanAsked:
Who is Participating?
 
Harry LeeCommented:
You will have to reorganize your data a little bit, then create a pivot chart.

This would be the easiest way to do it.

See the attached spreadsheet.

To switch the order of Gold, Silver, and Bronze, right click on any of the word gold in the pivot table, choose move, then move up or down.

You can use different chart types for the pivot chart. Just try different ones and see which one you like the best.
Line-Graph-Example.xlsx
0
 
brasimanAuthor Commented:
Ah, you're awesome! Thats exactly what i'm looking for. Thank you!!!
0
 
Harry LeeCommented:
I'm glad I can help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.