lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I created a pivot table from Date and Number of employees. The table is as below. I want to create chart from that table.
I did but X-axis is showing the year like below and that makes the chart crowded. I went to format X-axis-->axis option-->Number-->format code and the type YY but did not work!
Any suggestion how to format date in pivot chart X-axis? Thank you so much.
19/08/1991 - 07/02/1997 9
08/02/1997 - 31/07/2002 7
01/08/2002 - 21/01/2008 11
22/01/2008 - 13/07/2013 11
14/07/2013 - 02/12/2017 11
I created a pivot table from Date and Number of employees. The table is as below. I want to create chart from that table.
I did but X-axis is showing the year like below and that makes the chart crowded. I went to format X-axis-->axis option-->Number-->format code and the type YY but did not work!
Any suggestion how to format date in pivot chart X-axis? Thank you so much.
19/08/1991 - 07/02/1997 9
08/02/1997 - 31/07/2002 7
01/08/2002 - 21/01/2008 11
22/01/2008 - 13/07/2013 11
14/07/2013 - 02/12/2017 11
Last edited:
