Can I change the text in a pie chart (% to xx)

L

Lennart

If I would like to change the text % that is optional in a pie chart, is this
possible?
The percentage i still valid to get 100 % but I would like to have another
text for each piece of the pie chart.
 
P

Paul Herber

If I would like to change the text % that is optional in a pie chart, is this
possible?
The percentage i still valid to get 100 % but I would like to have another
text for each piece of the pie chart.

Open the Document Explorer window (menu View -> Document Explorer)
select the shape to want edit
find the shape in the document explorer window, expand the shape to see the individual
pieces, when the part you want to edit is selected, use the Text Tool button on the
toolbar. You can now edit the text of the segment. The normal text is a text field, you
can either overwrite it or add to it. Use the Pointer tool to finish editing.
 
W

WapperDude

Here is an alternative approach.
Select the pies shape, click again to select the desired "wedge". Open the
shapesheet for this wedge, (Menu Bar > Window > Show Shapesheet), scroll down
to the Text Fields Section. The entry for Value should be something like
20%.

Click on this cell, in the formula bar at the top of the window, the entry
should be something like =Sheet.1!Prop.Pie5&" %".

Change the formula to something like =Sheet.1!Prop.Pie5&" %" & CHAR(10) &
"Toys".

Your wedge will now show 20% Toys on two lines.

HTH
Wapperdude
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top