Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I change the date format on the Pivot Chart axis?

April 26, 2017axis chart format Pivot

0

Posted

How can I change the date format on the Pivot Chart axis?

1 Answer

0

Posted

The pivot chart date formats are controlled by the field format in the PivotTable. To change the date format: • Right-click a date in the pivot table (not the pivot chart). • Click on Field Settings • Change the Number Format to the date format that you want. 1. Pivot Tables — Dynamic Data Source 2. Pivot Tables — Data Field Layout 3. Pivot Tables — Show and Hide Items 4. Pivot Tables — Clear Old Items 5. Pivot Tables — Field Settings 6. Pivot Tables — GetPivotData 7. Pivot Tables — Grouping Data 8. Pivot Tables — Multiple Consolidation Ranges 9. Pivot Tables — Printing 10. Pivot Tables — Custom Calculations 11. Pivot Tables — Pivot Cache 12. Pivot Tables — Protection 13. Pivot Tables — Grand Totals 14. Pivot Tables — Running Totals Contextures Pivot Table Blog Top of Page | Main Index Home Excel Tips Excel Files The Excel Store Blog Contact Privacy Policy Contextures Inc., Copyright 2009. All rights reserved.