When using the pivot table and chart in excel, I want to format the chart to
have distinct data series formats. However, when I change the selection in
the pivot table, the charting formats return to the defaults. I want to keep
this chart formatting regardless of how many time the data displayed is
changed. Is this possible?