Population Pyramid and Negative Numbers

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

Guest

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.
 
Hi,

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

Cheers
Andy
 
Back
Top