« Not-so-hot news boxes | Main | Google trends 2 »



Agreed on the ugliness of the Spider graph (thanks ms!).

I have a more general question about 3D plots. In your opinion when is a good time to use a 3D plot?

Currently I'm working on a competitive release diagram that compares the number of press releases coming out of a set group of competitors (over time). There are 8 competitors plotted so the 2D line graph gets ugly and hard to read. But the 3D has to be angled and sorted in order to be legible.

Any thoughts or guidelines on when 3D is appropriate?

(I'm not sure if this is the appropriate forum to ask but I love this site and spend 80% of my time charting so it's been invaluable.)



Jon Peltier

This type of chart (3D Line, aka Ribbon Chart) has been available in Excel for many versions, since at least Excel 97. It took Excel 2007, though, to boast about it, and to put the potentially useful but more probably disastrous conditionally formatted table in the same view.

For the record, there are no new chart types or features in Excel 2007, But they have added the ability to apply gradients, shadows, blends, 3D marker and bar effects, and other "professional" formatting styles.

- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services

Kelly O'Day

1.When are 3-D charts useful ? Never! to me, 3-d charts are usually chart junk.

2. How can you show your 8 competitors in 2D and still be readable?

Use a stacked XY chart. This approach borrows from trellis - lattice chart techniques of S-Plus, R.

I have an example stacked XY chart on my site. I also show a parallel XY chart.


I'll be glad to walk you through going from my example of 4 stacked series to 8 if you want to try this approach. Just email me koday@processtrends.com


John S.

I just realized where I've seen that figure before: it looks like the wad of staples I pull out of my stapler every time it jams up.


just came across this lovely site!

i never use 3D charts. if a chart looks incomprehensible, then throw it away! pcmag obviously got it wrong. you can do better with office 2007! have just have a look what i did and klick on my name..

The comments to this entry are closed.


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Keep in Touch

follow me on Twitter