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

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341e992c53ef00d834c37eac69e2

Listed below are links to weblogs that reference Microsoft and innovation:

Comments

katm

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.)

Thanks!

Kat

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
http://PeltierTech.com/
_______

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.

http://processtrends.com/pg_charts_stacked_transformed_data.htm

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

..Kelly

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..

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Marketing analytics and data visualization expert. Author and Speaker. Currently at Vimeo and NYU. See my full bio.

Book Blog



Link to junkcharts

Graphics design by Amanda Lee

The Read



Good Books

Keep in Touch

follow me on Twitter

Residues