I have a Pivot Chart with data used as row labels. When an option is deselected, the option disappears from the filter list and has to be readded back, which is non ideal since it has been relabelled and the relabelling is lost when that data field is added back in.
Before deselection: http://farm4.static.flickr.com/3364/3661401099_c76d2dde9b.jpg?v=0 Deselection: http://www.flickr.com/photos/40657932@N00/3661401105/ After deselection: http://www.flickr.com/photos/40657932@N00/3661401107/
The pivot chart is generated from VBA code. Is there a way to prevent this from happening?