[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

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
0
brasiman
Asked:
brasiman
  • 2
1 Solution
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now