PivotChart is not aligned with pivot table in terms of axis format

[michellelyxs]

Hi guys,

I have this axis format problem for some of my pivot charts(not all of them) -- the axis format cannot be changed to the expected date format mmm-yy:

The table behind is the source table, in which the date format is good tho.

Any idea why this happened?

Thanking you

 

[Domenic]

Right-click the pivot field for your date, select Field Settings, select Number Format, and then select your desired format.

Actually, it looks like you've already done so. In that case, right-click the pivot chart, and select Refresh Data. If this doesn't work, try changing the format for your pivot field to some other format, and then change back again to see if it helps.