Hi - I am trying to format x-axis in a pivot chart from m/d/y to mmm-yy. I
set the format to mmm-yy but it still appears as m/d/y. Even when I open the
format window for the primary horizontal axis, the mmm-yy format is selected
but the x-axis still displays m/d/yy. Any ideas of what to check next?
thank you!

"Mike Middleton" wrote:

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.

.