This is a know bug.
More detail here including link to MS article
http://www.contextures.com/xlfaqPivot.html#ChartFormat