|
Re: Keep Pivot Chart Formatting on Refresh
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.
|