•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pivot table date format
Hoping for some help.
I have data that I wish to use in a pivot table. The date on the data it 12/03/26 e.g but if showing in the cell as wed, 12/03/26 which is what I need as the day of the week is important when veiwing the data in the pivot chart. However, when putting the column of data into the pivot chart it is showing as 12-March. I cannot seem to find a way to make it appear as it does in the formatted original column. Easy one?
Dates for example and may not make calender sense :)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives
#pivot table
#date format
#pivot chart
#day of the week
#data