Lizz45ie -

For an Excel 2007 PivotChart, to change a numerical axis format, select the
PivotChart, choose PivotChart Tools | Layout | Axes | Primary Horiz/Vert
Axis | More Primary Horiz/Vert Axis Options, and in the Format Axis dialog
box choose Number ...

- Mike
http://www.MikeMiddleton.com



"Lizz45ie" wrote in message
...
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.