Population Pyramid and Negative Numbers

[BoRed79]

Dear All.

I have created a population pyramid graph, which uses negative percentages
to show one side of the pyramid.

On my x-axis and on the data labels, I do not want to show these as negative
numbers.

I have followed the following instructions:

In the Format Axis - Number tab - I have selected the Custom option and
typed in 0;0 (which I understood would take care of the negative number).
However this has just left me with a series of 0 and 1 label.

Can anyone suggest another way of doing this??

Thanks in advance.

 

[Andy Pope]

Hi,

If you x axis values are less than 1 then try this number format.
0.#;0.#

Cheers
Andy

 

[Jon Peltier]

Or, since it's percentages,

0%;0%;;

- Jon

 

[Andy Pope]

Thanks Jon. I missed the percentage keyword.

Cheers
Andy