Most underappreciated Excel chart

3,075 Views | 22 Replies | Last: 4 yr ago by The Dog Lord
BaitShack
How long do you want to ignore this user?
I'll go with the 100% stacked bar chart.

BBRex
How long do you want to ignore this user?
Ha! Most of the folks in my department (top to bottom) look at me like I created fire just by being able to make a pivot table. Making an actual chart would blow their minds.
Claude!
How long do you want to ignore this user?
Why does Alberto need so much fruit compared to everyone else?
TexasRebel
How long do you want to ignore this user?
That stacked bar chart is trash.
BlackGoldAg2011
How long do you want to ignore this user?
Box and whisker plot or gtfo
Iowaggie
How long do you want to ignore this user?







Hwy30East
How long do you want to ignore this user?
One of my greatest fears is that someone is going to tell me to make a pivot table! I'm an old, so I would just have to tell one of my underlings to do it ASAP!

There's a few in my department that like to play with Excel at home and on weekend's. They've really got to be fun at parties.
Anchorhold
How long do you want to ignore this user?
Bikini chart on top of a nice curve graph.
THE_CHOSEN_ONE
How long do you want to ignore this user?
BaitShack said:

I'll go with the 100% stacked bar chart.



They used the wrong colors for everything in this chart
ThunderCougarFalconBird
How long do you want to ignore this user?
Claude! said:

Why does Alberto need so much fruit compared to everyone else?
because he's a Mexican.
BBRex
How long do you want to ignore this user?
That's like a lot of director and above folks here. "Pivot table" means you pivot to someone on your team and ask if they can make a table.
ABATTBQ11
How long do you want to ignore this user?
Only when it's a line chart
ABATTBQ11
How long do you want to ignore this user?
BBRex said:

Ha! Most of the folks in my department (top to bottom) look at me like I created fire just by being able to make a pivot table. Making an actual chart would blow their minds.


Break out a VBA module and they'll think you're Zeus himself
BenTheGoodAg
How long do you want to ignore this user?
Damn Susie
Win At Life
How long do you want to ignore this user?
I used to rock at Quatro Pro.
Aggie Joe 93
How long do you want to ignore this user?
I've taken to creating my pivot tables during the screen share.

It generally takes about 8 seconds to make a pretty functional chart if you already know your metrics have your data and know what you want to show.
Ulrich
How long do you want to ignore this user?
Hwy30East said:

One of my greatest fears is that someone is going to tell me to make a pivot table! I'm an old, so I would just have to tell one of my underlings to do it ASAP!

There's a few in my department that like to play with Excel at home and on weekend's. They've really got to be fun at parties.

I have pulled out a computer to show off a fun model or simulation at more than one party….
Ulrich
How long do you want to ignore this user?
Aggie Joe 93 said:

I've taken to creating my pivot tables during the screen share.

It generally takes about 8 seconds to make a pretty functional chart if you already know your metrics have your data and know what you want to show.

Blow their minds by hitting CTRL SHIFT R CTRL SHIFT D ALT N V ENTER ENTER so the pivot table appears as if by magic.
500,000ags
How long do you want to ignore this user?
Nothing like some 55 year old senior director adding another % of total row. Classic.
Hwy30East
How long do you want to ignore this user?
Ulrich said:

Hwy30East said:

One of my greatest fears is that someone is going to tell me to make a pivot table! I'm an old, so I would just have to tell one of my underlings to do it ASAP!

There's a few in my department that like to play with Excel at home and on weekend's. They've really got to be fun at parties.

I have pulled out a computer to show off a fun model or simulation at more than one party….


I bet it wasn't one of those "Here hold my beer and watch this." Moments. Lol…
GarlandAg2012
How long do you want to ignore this user?
Hwy30East said:

One of my greatest fears is that someone is going to tell me to make a pivot table! I'm an old, so I would just have to tell one of my underlings to do it ASAP!

There's a few in my department that like to play with Excel at home and on weekend's. They've really got to be fun at parties.


"I'm inept! People with more skills than me are lame."
StinkyPinky
How long do you want to ignore this user?
Always go with a scattergram. By default they just show a bunch of scattered data without requiring you to draw a conclusion.
The Dog Lord
How long do you want to ignore this user?
GarlandAg2012 said:

Hwy30East said:

One of my greatest fears is that someone is going to tell me to make a pivot table! I'm an old, so I would just have to tell one of my underlings to do it ASAP!

There's a few in my department that like to play with Excel at home and on weekend's. They've really got to be fun at parties.


"I'm inept! People with more skills than me are lame."

What's even funnier is how easy Pivot tables/charts are for most datasets. Most don't have the need for the more complex options.
Refresh
Page 1 of 1
 
×
subscribe Verify your student status
See Subscription Benefits
Trial only available to users who have never subscribed or participated in a previous trial.