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


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.


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)


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


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


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.


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


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:


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


That makes an "invisible" percentage sign.



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.


Sweet Excel tip. Thanks!

The comments to this entry are closed.

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