Chart Conditional Formatting?

I have a Pivot Chart with 5 data series requiring 3 different formats.

Data: In my Pivot Table I have the following Fields - Type, Year, Month, Sales.

The Years are always the most Recent 2 Years (Currently 2011,2012).

The Months are, well, the Months Jan Through Dec.

The Sales are 'Number of Sales in The Period'

The Type is one of 3: Sales, Cumulative Sales and Change.

Sales has a field for every month in 2011 and 2012, the same for cumulative and finally, Change has the difference between 2011 and 2012 sales for each month.

Now when I plot these on the chart I have

Sales 2011, Sales 2012 Plotted as a line chart on the primary axis,

Change Plotted as a bar chart on the primary axis, with invert if negative formatting,

Cumulative Sales 2011, Cumulative Sales 2012, Plotted as a line chart on the Secondary axis. With the same colours per year as Sales, but as a Dashed Line.

I want this formatting to remain static as the data updates, and if possible when the series changes name (which i'm not sure is possible) because, come January the data series will be 2013/2012 not 2012/2011.

With the other formatting is seems to sometimes stay static and sometimes just decides to reformat everything and switch axes and i'm not really sure why.