CaptainTrips
New Member
Hello,
I've entered some data into Google's spreadsheet application, but I can't seem to get a decent bar graph out of it in either Google's App or Excel.
What I am looking to do is to make a bar graph in descending "Count" order. Each bar should be labeled with "Result" first, then labeled with "Prize" somehow.
Would it be easier if I combined column 1 with column 2? I had it that way originally, with the result on the first line, then I CTRL-ENTERED to make a second line in the same cell and added the "Result" there. I was able to get a strange shotty bar graph out of that, with the result (first line) under the bar truncated vertically and the "Prize" (second line) horizontally under the bar, making all the "Prize" outcomes overlap each other. The way I have it currently with two seperate columns for "Result" and "Prize" refuses to be a bar graph altogether in Google's App. Should I be doing this some way entirely different?
Here's a link to the graph. it's read only (because there are un-nice people out there) but you can easily copy/paste it into your own Google Spreadsheet or Excel.
https://docs.google.com/spreadsheet...01ZFpuVmhkbHNwV2RyVG9PWVE&usp=drive_web#gid=0
I'm open to suggestions on entirely different ways to present this data in graphical form. I'd like to do it on Google's Spreadsheet for it's ease of sharing with a link, but I suppose a screen shot of anything else, a little cropping, and imgur.com would work just as well.
Any help or advice would be appreciated!
I've entered some data into Google's spreadsheet application, but I can't seem to get a decent bar graph out of it in either Google's App or Excel.
What I am looking to do is to make a bar graph in descending "Count" order. Each bar should be labeled with "Result" first, then labeled with "Prize" somehow.
Would it be easier if I combined column 1 with column 2? I had it that way originally, with the result on the first line, then I CTRL-ENTERED to make a second line in the same cell and added the "Result" there. I was able to get a strange shotty bar graph out of that, with the result (first line) under the bar truncated vertically and the "Prize" (second line) horizontally under the bar, making all the "Prize" outcomes overlap each other. The way I have it currently with two seperate columns for "Result" and "Prize" refuses to be a bar graph altogether in Google's App. Should I be doing this some way entirely different?
Here's a link to the graph. it's read only (because there are un-nice people out there) but you can easily copy/paste it into your own Google Spreadsheet or Excel.
https://docs.google.com/spreadsheet...01ZFpuVmhkbHNwV2RyVG9PWVE&usp=drive_web#gid=0
I'm open to suggestions on entirely different ways to present this data in graphical form. I'd like to do it on Google's Spreadsheet for it's ease of sharing with a link, but I suppose a screen shot of anything else, a little cropping, and imgur.com would work just as well.
Any help or advice would be appreciated!
