Chart 'Conditional' Formatting

Hi Geniuses,

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.

With me so far?

Anyway,

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.

Anyway,

Any help with the best way to achieve this would be greatly appreciated (I can alter the tables SQL side if it needs to be arranged differently)

Thanks,

Andy

For conditional format.

Below is the link to learn more about it.

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

But for your question, I have no clue what is your problem faced.

You could try to make it to point form? Your problem and ideal solution?