In EXCEL 2007 check the following for the axis with which you are having a
problem:-

1. Click on the axis with which you are having a problem (I have clicked on
the Y axis which is formatted as Number in my underlying data).

2. Chart Tools / Format / Current Selection group / Vertical (Value) Axis -
you might need to change this setting to whichever axis it is you are having
a problem with) / Format Selection / Format Axis window should now launch /
Number / make sure that Number is selected and not Percentage.

If my comments have helped please hit Yes.

Thanks.




"Lizz45ie" wrote:

Hello,
I am trying to change the format of the Axis in my chart to a number format
but for some reason it will not work. The data that my chart is based on is
in Number format, the Axis is percentage format. I've tried everything I can
think of and nothing seems to work.

Any help will be greatly appreciated.