How do you keep a Pivot Chart's formatting after refreshing the data?
How do you keep a Pivot Chart's formatting after refreshing the data?
You actually have to format the pivot table, and not just the cell that it is sitting on. Basically, you have to right click on the pivot table and choose format cells (for labels), instead of going to the Format menu on the toolbar.
If you are formatting data, you can right click in the pivot table and choose "field settings" and click "number" if you need the number formatting to stay the same on data.
Loss of formatting is a known bug.
http://www.contextures.com/xlfaqPivot.html#ChartFormat
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks