Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: I've been sent a 3D Pie Chart.

  1. #1
    Board Regular Darren Bartrup's Avatar
    Join Date
    Mar 2006
    Location
    Nottingham (UK)
    Posts
    1,253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default I've been sent a 3D Pie Chart.

    Dear Forum,

    I've been sent a 3D Pie Chart and the sender is too far away to slap.... what should I do?

    I want to ask the sender about the size of two of the slices - they look pretty much the same, but the raw data suggests that one slice is 26% while the other is 14%.

    I'm thinking some kind of punishment is in order, but apparently I can't use capital punishment in a workplace environment.

    Does anyone have some code that will transfer an electric shock via a worksheet function?
    Using Office 2003 & 2010,

    I'm 1 of the 10 people that don't understand binary. Guess that means the other 1001 do.

    No answer to your post?
    Get someone to read it - does it make sense or does it sound like gibberish?

  2. #2
    Board Regular MrIfOnly's Avatar
    Join Date
    Nov 2016
    Location
    Wisconsin
    Posts
    419
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    Quote Originally Posted by Darren Bartrup View Post
    I'm thinking some kind of punishment is in order, but apparently I can't use capital punishment in a workplace environment.

    We need to change this law! Or, at the very least, allow corporal punishment in the workplace.
    *************************************************
    Rate Schedule:

    • Answers: $1
    • Correct Answers: $2
    • Dumb looks are still free.

    *************************************************

    Want to make your listbox column widths adjustable? Take a look at this YouTube video and this sample file on RoryA's informative website: Tips and tricks | Excel Matters

  3. #3
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,545
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    What's wrong with 3D Pie Charts? Are they generally frowned upon?

  4. #4
    Board Regular
    Join Date
    Sep 2016
    Location
    Canada
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    Quote Originally Posted by 63falcondude View Post
    What's wrong with 3D Pie Charts? Are they generally frowned upon?
    I concur, I don't understand the OP's post. Is this some sort of British humor I don't understand? Do people in England not like 3D looking objects? Please, enlighten me
    TIPS FOR FINDING EXCEL SOLUTIONS:

    1. Ask Google.
    2. Use the Search functionality on this board.
    3. A lot of VBA code can be acquired by using the Macro Recorder.
    4. Microsoft's Developer Network is your friend!

  5. #5
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    30,350
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    Quote Originally Posted by 63falcondude View Post
    What's wrong with 3D Pie Charts? Are they generally frowned upon?
    They're great as long as you're trying to:
    Distract people from the data; or
    Misrepresent the data; or
    Avoid ever being employed as an analyst; or
    Get a job in marketing.

  6. #6
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,545
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    Quote Originally Posted by RoryA View Post
    They're great as long as you're trying to:
    Distract people from the data; or
    Misrepresent the data; or
    Avoid ever being employed as an analyst; or
    Get a job in marketing.
    I see that you like them as well... Are 2D Pie Charts considered acceptable?

    When used correctly (i.e. parts representing a whole) I don't see the issue.
    Last edited by 63falcondude; May 19th, 2017 at 03:52 PM.

  7. #7
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    30,350
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    If you have 2 or at most 3 data points, they are tolerable. Otherwise they should generally not be used in my opinion. There's a good article by Stephen Few called "save the pies for dessert" that's worth a read.

  8. #8
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,545
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    Quote Originally Posted by RoryA View Post
    If you have 2 or at most 3 data points, they are tolerable. Otherwise they should generally not be used in my opinion. There's a good article by Stephen Few called "save the pies for dessert" that's worth a read.
    Thanks, I'll have to check it out.

  9. #9
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,580
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    Just to save anyone searching for it as I have just re-read it....

    https://www.perceptualedge.com/artic...or_dessert.pdf
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  10. #10
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    2,368
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I've been sent a 3D Pie Chart.

    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com