Can't change date format on Pivot Chart

**handerson0603** · 08-29-2013, 10:27 AM

I can click on "Format axis" and change the number format, but nothing changes. I also tried "Link to source data" but checking that and changing the format in the source data has no effect.

I tried creating a standard chart based on the same source data, and the date formats change as I click on the different formats. This only seems to apply to Pivot Charts.

I have tried this on a couple of my own charts and on 3 or 4 that I have downloaded from various forum posts, all with the same result. Is this a bug in 2010? Anyone else having this issue?

**romperstomper** · 08-29-2013, 11:46 AM

Do your date fields contain blanks? Did you set the format for the pivot field in the pivot table, or the cells it occupies?

**handerson0603** · 08-29-2013, 11:59 AM

No, my date fields don't contain blanks. I set the format by right-clicking the date axis and choosing "Format axis". When I do the same thing on a normal chart, it works fine.

I assume this is working for you? Could it be something our Corporate IT inadvertently disabled when configuring Office?