Round data labels in PPT chart?

2817 views
Skip to first unread message

jenant

unread,
Oct 6, 2009, 10:16:01 PM10/6/09
to
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

unread,
Oct 7, 2009, 9:28:01 AM10/7/09
to
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.

Steve Rindsberg

unread,
Oct 7, 2009, 10:12:56 AM10/7/09
to
In article <0F91A9D1-1048-4729...@microsoft.com>, Jenant wrote:
> 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'm guessing that you could create the chart in Excel instead.
Put the real data in one worksheet or section of a worksheet then copy/paste it
to another. In the copy, apply formatting that gives you the results you want,
then create your chart from that data instead.

==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

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

Echo S

unread,
Oct 7, 2009, 12:07:37 PM10/7/09
to
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


"jenant" <jen...@discussions.microsoft.com> wrote in message
news:0F91A9D1-1048-4729...@microsoft.com...

Reply all
Reply to author
Forward
0 new messages