The drop down menu in the Axis Fields area for this field brings up a dialog
which includes two tabs: "Subtotals & Filters" and "Layout & Print". Neither
of these has a number format control that I can find...

"Shane Devenshire" wrote:

Hi,

Sorry about that last post, the steps are correct but there is no result,
however, I found one that works -

With the chart selected and the Pivot Table Field List displayed click the
Date field in the Axis Fields area to open the list and choose Field
Settings, Number Format, ...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dsm" wrote:

Sorry I should I have mentioned this is excel 2007 with SP 2. As you might
infer from the note below I know how to do this on excel 2003, but on 2007 it
doesn't work.

"dsm" wrote:

If I have a pivot chart with dates on the x-axis, I am unable to "number"
format the axis. My source data has dates formatted to "Mar-09", but the axis
shows "3/1/2009". If I format the dates in the pivot table they look fine,
but the chart still shows "3/1/2009". I believe with 2003 I could format the
dates in the table and they would be reflected in the charts. If I use format
axis on a pivot table axis it has no affect at all.

This seems like a glaring hole for producing business charts so I must be
missing something new.

Steve