Hi Shane,

Can you be abit more clear regarding the Axis area. With the chart selected
and the Pivot Table Field List displayed I did select the Date filed and
double clicked the Date
Date field in the Axis Fields area to open the list and choose date button Field, but it displays only the filters and no where i see the number field to change the format of the date.

Could you please elaborate the explanation and make me clear. I am very new
to Advanced usages of Microsoft Excel.

Thanks,
SKR

"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