Search code examples
sharepointexcelsharepoint-2010

Why Excel Services does not keep pivot chart style when date changes?

I'm experiencing a problem with Excel Services and charts:

If in my excel pivot chart I use the default style, when publishing the excel to sharepoint all goes well. When I try to make some customization on the pivot chart (e.g. add data labels) they are kept unless the pivot data is updated adding a new row.

Specifically, I have pivot data with dates as rows and the filter is saved on "Today". When the day change, my chart style is lost (reverted to the default one).

Does anyone know about this odd behavior? Is there some setting in excel or Excel Service I'm missing?

Thanks

Solution

  • In client Excel, refreshing the pivot table often reverts formatting of the table and related chart to the default. Microsoft doesn't quite admit it's a bug, but suggests recording a macro when you reformat your chart, so you can rerun the macro. I suppose this doesn't help in Excel Services.