Unable to Format Pivot Chart Axis Labels

[AndyRI83]

Hi,

I'm trying to format the labels on the X-axis of a Pivot Chart. Of note, this chart was created from my Data Model; not from an existing Pivot Table.

The axis I'm working on displays dates. The current format is MM/DD/YYYY. This is not ideal, since the chart is used to display a full month at a time. Since the text of these labels is so long, I end up with that awful "tilt your head sideways to read the labels" situation after a few weeks worth of data has been entered each month:

It appears the easiest way to fix this issue is to change the date format displayed on this axis to MM/DD. This chart is part of a dashboard with one universal timeline at the top that's linked to all the data, so displaying the year on the chart is not especially important to me.

The problem I'm having is that the labels remain formatted exactly as they appear in the screenshot above even when I attempt to change their formatting:

Next, I attempted to fix the issue by reformatting the dates in the data model itself:

Unfortunately, the MM/DD format is not an option in PowerPivot (even if I look through the many options under "More Date Formats..."

At this point, I'm stumped! Any suggestions?

Thanks!

 

[Domenic]

Try the following . . .

1) right-click the pivot field

2) select Field Settings

3) click on Number Format

4) select Custom

Then enter your desired format under Type.

Hope this helps!