Hi,
I have a query where one of the fields is a calendar date. The field is set to type = date in the query. I returned the data to a table and also selected the option to add the data to the data model. I then wanted to create a pivot chart using the data in the model. The chart shows the data on a monthly basis along the horizontal axis. It all works ok except that the date is being displayed as dd/mm/yyyy. I want to display it as mmm-yy. I can't for the life of me get the format to change. Any ideas?
Thanks
Bax
Hi Bax,
You can't change the format of date fields in the Pivot Chart. Your options are:
1. Group the data by month and year in the PivotTable and nest these row labels in the chart. This will display the month names as 'mmm' and the year underneath.
2. Add a column to your dataset that displays the months in the format you want and use this in your chart. Note: you may need to add a 'sortby' column to avoid them being sorted alphabetically.
Personally, I'd use the first option as the second option adds data to your file that you don't really need.
Mynda