- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Help me OT-WAN Kenobi, you're my only hope - excel graph help.
Posted on 4/29/15 at 9:02 pm
Posted on 4/29/15 at 9:02 pm
Greetings, Gents.. Paige,
Yes I've exhausted google and youtube for this info.
Let's say that I have column A that list movie titles, column b list the genre, C lists the budget, D lists the gross sales, and E lists the dollars earned per budget dollar(Ratio 1 Column). I.E.:
ET Family Adventure $10.5M $435M 41.42
However, I have 50 movie titles that descend according to ratio. How can I select the genre column and ratio column to create a bar graph without the bar graph replicating a genre that has already been used?
Is this even doable?
TIA
Yes I've exhausted google and youtube for this info.
Let's say that I have column A that list movie titles, column b list the genre, C lists the budget, D lists the gross sales, and E lists the dollars earned per budget dollar(Ratio 1 Column). I.E.:
ET Family Adventure $10.5M $435M 41.42
However, I have 50 movie titles that descend according to ratio. How can I select the genre column and ratio column to create a bar graph without the bar graph replicating a genre that has already been used?
Is this even doable?
TIA
4
Posted on 4/29/15 at 9:02 pm to TigerDik86
Why
Posted on 4/29/15 at 9:03 pm to TigerDik86
pivot table
Posted on 4/29/15 at 9:04 pm to djangochained
quote:
djangochained
for statistical data, of course
Posted on 4/29/15 at 9:04 pm to TH03
quote:
TH03
BOOM this is what I needed. Thank you
Posted on 4/29/15 at 9:05 pm to TigerDik86
Do a sumifs at bottom, summarizing by genre and use that as your data set for the graph.
Or use a pivot table and pull in genre but not movie as row, and ratio as metric
Assuming I read your question correctly
Or use a pivot table and pull in genre but not movie as row, and ratio as metric
Assuming I read your question correctly
Posted on 4/29/15 at 9:05 pm to TigerDik86
Pivot table and graph
Posted on 4/29/15 at 9:05 pm to TigerDik86
yea, you should be able to avoid repeating genres that way.
Posted on 4/29/15 at 9:10 pm to Swoopin
Thanks guys! Truly, you've made my night a bit easier. =sumif is another great idea.
10/10 will use all advice.
10/10 will use all advice.
Posted on 4/29/15 at 9:11 pm to Swoopin
sumif is solid too.
I just prefer pivot tables because you can do whatever you want with it.
I just prefer pivot tables because you can do whatever you want with it.
Posted on 4/29/15 at 9:19 pm to TH03
quote:
I just prefer pivot tables because you can do whatever you want with it.
Pivot tables, the most awesome thing about excel that I never use
Posted on 4/29/15 at 9:31 pm to TH03
Yeah I've used pivot tables for years but have recently learned that sumifs is sometimes better once you've learned vba. At least in my job
Posted on 4/29/15 at 9:55 pm to TH03
quote:
I just prefer pivot tables because you can do whatever you want with it.
Just like your mom
Posted on 4/29/15 at 10:02 pm to Swoopin
I find the sumif results easier to work with in graphs.
The sumifs for each genre should be easy to set up.
The sumifs for each genre should be easy to set up.
Posted on 4/29/15 at 10:14 pm to TigerDik86
quote:
OT-WAN Kenobi
quote:
excel graph help
...wish I had something to do with my free time....
Page 1 of 1
Back to top
Follow TigerDroppings for LSU Football News