Hello
I am trying to create a bar chart using the data set created from pivot table, date format in Pivot table shows correct format d/mm/yyyy, however on the chart it shows as 44556 etc
I have tried the suggestions from the forum ...
1) right click on date column > Ungroup, right click format cells > Date format type m/dd/yyyy - this didn't work
2) right click on date column > Ungroup, right click format cells > Custom format type m/dd/yyyy - this didn't work either
3) I do not see a button with name "NUMBER" to change the formatting of the date format ... (see attached image)Excel 365Pro.PNG
I am using Office 365 Pro
Need help
Bookmarks