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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
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.

Or, since it's percentages,

0%;0%;;

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
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.

Thanks Jon. I missed the percentage keyword.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jon Peltier" wrote in message
...
Or, since it's percentages,

0%;0%;;

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
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.