Pie chart percentages without "%"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get pie charts to show percentages without the "%"

I want a pie chart for the series 2,1,2 to show the percentages as 40, 20, 40
Getting 40%, 20%, 40% is easy, but I don't want the "%"

Anyone?

/Pete56
 
You can calculate the labels on the worksheet, then use the calculated
labels in the chart. For example, with labels in cells A1:A6, and values
in B1:B6:

In cell C1, enter a formula to combine the text label and percentage:
=A1&" " &TEXT(B1/SUM($B$1:$B$6)*100,"#")
Copy the formula down to cell C6
Select the chart
Choose Chart>Source Data
Select the Series tab
Change the Category labels to: =Sheet1!$C$1:$C$6
Click OK
 
Yeah, explain to your boss about rounding errors. I'd prefer 40, 20, 40,
because at least that shows the two large bits being equal. Or give him
40.3846153846154, 19.2307692307692, 40.3846153846154.

Dogbert: 40% of your employees' sick days come on Mondays and Fridays.
Pointy Haired Boss: What kind of idiot do they think I am?
Dogbert: Not an idiot savant. They can do math.

(Sorry, couldn't resist!)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top