From: Jessetr on
Hello.

1. I did Chart / Insert / Chart

2. I created a stacked column chart (2D).

3. My datasheet: Cell A1 = 28. Cell A2 = 15. Cell A3 = 5. B1 = 35. B2 =
20. B3 = 8.

4. I right-clicked each section of the stacked column (in empty space, not
on the number itself), clicked Format Data Series, clicked on the data labels
tab. Checked “Value”. Clicked OK.

5. I went back to the chart, right clicked on the actual value, clicked
Format Data Labels. Clicked on the Number tab.

6. Under Category, I chose Custom. Typed in <quote> 0#”%” <end quote>.
This allows percentages to show up as 20% instead of 2000%.

7. My problem: All numbers under 10 now have the uncessary and unsightly
“0” in front of them. For example, instead of 5% it now reads 05%.

If you know of a workaround, or can point out where I went astray, I would
greatly appreciate your reply.