Round data labels in PPT chart?

[jenant]

Is there a way to round and concatenate data labels in a PPT chart? I have a
data series I'd like to plot using the "real" data (e.g., $1,095), but I want
each data point to show the value rounded to the nearest $1,000 and
shorthanded (e.g., $1k). Is that possible? I know I can do it manually, but
the data will need frequent refreshing, so I don't want to have to do it over
and over.

I believe ThinkCell can do this, so I'm hoping there's a way to trick PPT
into doing it too.

Thank you!

 

[Cosmo]

What version of PowerPoint are you using, and what type of chart are they?

If they are Excel charts , then you could add formula to cells that formats
the entered value to divide by 1000 and use those for your data for the chart.

 

[Echo S]

You should be able to do this with a number format. Use $0,"k" for the
format.

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

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.

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

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

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

Don't Miss the PPTLive User Conference! Atlanta | Oct 11-14