Thursday, February 10, 2011

Excel - How to Round Data Labels in Charts

Here's how to change your chart labels from actual data to something like $1K.


Apply it by right-clicking the data label and going to the number tab, then in the Custom category. Type $0,"k" in the "type" box and hit OK. 


[If using Microsoft 2007, then click on the "Format" tab, "Format Selection", "Number" and then type into "Format Code" box: $0,"k".]


Jon Peltier (first link below) has a great page of information about number formats, and he spells out thousands, millions, etc., specifically toward the bottom of the page. The Office Online article will also give you a good overview so you can understand what's going on with the dollar sign and the K inside quotation marks. Thanks to Echo S.

http://peltiertech.com/Excel/NumberFormats.html 

http://office.microsoft.com/en-us/excel/HP012165031033.aspx?pid=CH100... "

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...