J
Jessetr
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.
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.