User defined charts
 

Morning All
Have set up a user defined chart - to chart a target percentage Bar 100%
with another bar next to it with the performance target acheived eg 80%.

In the user defined chart the Target percentage is the first bar and
coloured blue
and the performance percentage is red and the second bar.

When I chart the next months data the above bars are reversed and the
colours are swapped over; this means I have to go in and change the
formatting over each time I create the chart using this user defined template.

Would appreciate any ideas as to what I am doing wrong / right,

TIA
Ajay