« Pies fail to deliver | Main | Two RSS feeds »

Comments

Naomi B. Robbins

Nice job. However, both the pie chart legend and the table could be improved by lining up the decimal points so that the weights were easier to add. Of course, you already did the most important addition for the readers. Also, the weights would be easier to read if they were not cluttered by so many percent signs; I'd prefer the % in the column label or the first row only.

derek

In tables I've taken to eliminating vertical borders and grid lines altogether. With aligned text and numbers they turn out to be redundant, or to actively inhibit reading the columns properly.

(when I do this, I also align the labels on the top in whatever way the data is aligned-- in other words left aligned labels for text, right aligned labels for numbers, even though the label isn't a number)

John

Let's just have a moratorium on 3D pie chart posts, huh?

Kaiser

John: Huh? When was the last time I posted about a 3D pie chart?

Kaiser

Naomi and Derek: Is there an easy way to do this right alignment in Excel? I don't want to give up the right indent though. I need it to be aligned on the right with white space between the % and the column border.

Tom West

Derek: "In tables I've taken to eliminating vertical borders and grid lines altogether"
I've gone the opposyite route - it's horizontal lines which are redundent. Our eyes are good at tracking across horizontally, from years of reading stuff.

derek

Kaiser, I don't have the border, so that's not a problem for me. But if you want white space between the right hand edge of a cell and the text and number alignments, and you don't want to use right align, then a custom number format that uses the underscore will do it. Underscore creates a white space the size of whatever character comes immediately after the underscore, so

0%_M;-0%_M;"none"_M

will produce a percent format with a space the size of a capital M on the right.

@_M will do the same for text, and I think you can combine the two into one:

0%_M;-0%_M;"none"_M;@_M

Obviously you don't need that fancy "none" format, but you need something for when the value is the number zero.

If you want a format that will lack the percent sign, yet line up with numbers that have the percent sign, as Naomi proposes, you can use the underscore and a percent, like so

0_%

That makes an "invisible" percentage sign.

John

Kaiser,

Aug 10, but the previous post was also on pies.

Huge fan, so don't take it the wrong way, but pies and esp. 3D pies are just too easy. Fish in a barrel.

derek,

Sweet Excel tip. Thanks!

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