Do Not Build This 3-D Chart in Excel

My eyes are still burning from this experiment, so read on at your own risk!

Last week, you saw this book cover, here on the Contextures blog. I asked if you, as the author, would approve the cover artwork.

excel2010madesimple

There were several comments, with most people agreeing that they would have selected a different chart example. This kind of pie chart isn’t available in the built-in Excel chart types (thank goodness!), so why promote it on the cover?

Yes You Can Build It

However, Excel guru Andy Pope (who might not want his name mentioned in connection with this abomination), pointed out that you can indeed build this chart in Excel, by using Smart Art. You can read the comments to see the jokes about that name. ;-)

And he is right! Below, you can see the chart that I created in Excel 2010, so stop reading now, if you have a sensitive stomach. It’s not an exact reproduction of the cover chart, but as close as I could get before the paramedics arrived.

stackedpie01

The Smart Art Instructions

Here are Andy’s instructions, for creating this chart. If you try it, please burn the chart immediately after finishing it, so it doesn’t spread into the wild!

To create the stepped pie chart:

  • On the Excel Ribbon, click the Insert tab, and click Smart Art

stackedpie02

  • A blank chart is created, with 3 equal-sized slices. Up to 7 slices are available, so I created 7 bullets, with a space character after each bullet. One slice was “exploded”, so I dragged it in, to line up with the other slices.

stackedpie03

  • On the Ribbon’s Design tab, select one of the 3-D styles, e.g. Bird’s Eye Scene.
  • Right-click one of the slices, and click Format Shape
  • In the Fill Category, select a colour for the shape – the gaudier the better!
  • In the 3-D Format category, set the depth for the slice. In my chart, the 2 red slices are 90 pt.
  • In the 3-D Rotation category, set the distance from ground to the same setting as the depth

stackedpie04

  • Format the remaining slices, with the colours, depth and distance from ground varying, to create the stepped effect. I used all the colours of the rainbow, and depths of 10, 20, 40, 60, 80 and 90. Awesome!

stackedpie05

  • To merge the 2 red slices, and flatten all the tops, I changed the Bevel setting for the Top to No Bevel, in 3-D Format, for each slice.
  • Then, you can play with the other settings, like Gradient fill and Perspective, to create a unique work of art.

And remember – do not use this chart type in your Excel workbooks! Now I have to go and wash my hands.

___________

You may also like...

13 Responses

  1. Doug Glancy says:

    Debra, I know you don’t like it, and I understand why, but I have to say it’s very attractive. The colors, sizes and perspective are harmonious, and the overall effect is quite pleasing (none of which was true with the original). Along with your other talents I think you have a knack for Smart Chart Art!

  2. P.J. says:

    Too funny…

  3. mustafa says:

    I could’nt do this could you please add a sample file..

  4. IEatPies says:

    Thanks for the tip. I think I’ll build an add-in with custom steps and sizes.

    Then I’ll sell it to Jon Peltier so he can add it to his collection that clearly miss this great feature. I’m sure he’ll like it :P

    (
    ( ) )
    ) ( )
    …..
    .:::::::::.
    ~\_______/~

  5. Jon Peltier says:

    We’re gonna have to deploy two teams of commandos, one to take out Andy, and one to take out Debra.

  6. Ed Ferrero says:

    I’ve seen that chart before… where was that? Oh, yes http://www.motifake.com/135400

  7. General Ledger says:

    It is visually interesting even to someone who is color blind. However, it is just a SmartArt graphic. It is not a chart and is not dependent on data for its dimensions. Until that happens, I don’t think any of us have to worry about it becoming a mainstream technique.

  8. Patrick M says:

    Too funny, Jon :)

  9. Patrick M says:

    Gobish, in the immortal words of Admiral Akbar, “It’s a trap!”

  10. I_will_adapt says:

    I never liked charts, still can’t get to love them. but a nice try.

  11. Fred C says:

    Well it pays to read down the e-mails instead of up from old to new. Then again what else would I do. Got behind in computer work, pleasure comes second.

  12. Maxim Manuel says:

    Funny and instructive Debra. Lol

    Let’s call a priest to exorcize this chart.

    So bad we cannot connect it to the sheet data. Just guessing.

  13. Tony says:

    Can I just say, that I know people who would like this kind of ‘chart’ to the extent of being ‘quit excited’. Unfortunately, as these ‘people’ are in a higher position than me, outing them could be a backward career move!

Leave a Reply to I_will_adapt Cancel reply

Your email address will not be published. Required fields are marked *