Round data labels in PPT chart?

  • Thread starter Thread starter jenant
  • Start date Start date
J

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!
 
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.
 
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
 
Back
Top