Date formatting in Pivot Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to create a pivot chart and the date field is not formatting
properly - the format comes out different from that of the pivot table. How
can I fix this? Format axis doesn't give me an option for date format.
 
In the pivot table, right-click the date field button, and choose Field
Settings.
Click the Number button, and select a date format
Click OK twice
The chart should show the selected format.
 
Back
Top