Pivot Table -- Hide Fields instead of Remove Fields?

[timconstan]

I have a pivot table and a pivot chart setup. I want to chart each column in the pivot table 1, column at a time. If I uncheck the fields that I don't want in the chart, it takes them out of the value table, like I want it too. When I recheck to show that column, the options that I had set in the Value Field Settings are lost. Instead of removing/adding fields like this is there a way to hide/show fields or some other way to retain the settings for that field?

 

[Herbert Seidenberg]

Excel 2010 PivotTable
Maintain DataField formats.
http://c3017412.r12.cf0.rackcdn.com/04_25_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

 

[timconstan]

That's it! Thanks so much.

For others interested, here's another link with more instructions:
http://www.contextures.com/xlPivot08.html