Prev: Screen flashes when advancing to frame with .swf file
Next: How increase interval after last antimation and slide transition?
From: Jessetr on 30 Apr 2010 15:14 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. |