Hi,

The instructions doesn't apply to my chart because it is tied to a pivot
table. I don't see the menu for the Chart Tools. Is there a work around to
change the number format in a chart that is tied a pivot table?

"trip_to_tokyo" wrote:

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.