Pivot Table Axis format

[Mike D.]

Hi.

I have a macro that creates a pivot-table and pivot
chart. The X-axis is a date. In the raw data, the date
is formated as month/day. This is the way I want it on
the chart. However, the X-axis formats with
month/day/year. How can I force this to display correctly?

Thanks,
Mike.

 

[Dave Peterson]

Do you see a grey little dropdown under the X axis (where you can choose your
dates to show)?

If yes, then rightclick on it.
Select the top option: "Format pivotchart field"
then click on the Number button on the next dialog.

There are a bunch of date formats that you can choose from.

Maybe one will be ok.