How to format dates in a pivot chart?

[FleurDeList]

I have a field that is in date format in PowerPivot, but when I use it in a chart, I am not able to format it. It does not matter what I do. I have tried setting it to date using the chart format functionality or changing the formatting using a custom format and nothing works. The date displays as 1/1/2012. All I want is the year. I vaguely recall reading that dates in pivot charts cannot be set. On the other hand, I know I have formatted dates in charts, but they may have not been pivot charts.

Does anyone know if it is possible to change the date format in a pivot chart?

 

[NickyvV]

I don't know how to adjust the settings in the Pivot Chart. But I do have a workaround: you can make a new Calculated Column with the formula Year(column) and get that column in your PivotChart.

 

[FleurDeList]

I had already tried that (calculated column using YEAR()), but then the data was aggregated by year, which I did not want. I want the data to be displayed in the chart by months or quarters. I might try some variant of the calculated column workaround where I conditionally add the year to the calculated column if the month is January and use the date otherwise. Then I will only display January's label, which will be the year, in the chart. I think this may be about as close as I will get to the format I want without.

Thanks for the suggestion.