Thread: Pivot Table -- Hide Fields instead of Remove Fields?

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?

Solved: Need to consolidate ranges.

http://www.contextures.com/xlPivot08.html