Conditional colours in a chart?

I have a pivot table something like the one below:

               Limit      Machine1 Machine2 Machine3 Machine4  

Period    

01               5               1               1               5          9

02               6               3                1              2          7

03               2               4               6               4          6

04               2               4               8               9          6

Now say I want to do a stacked bar chart on the above data, which is easy with the chart wizard.  However I want to make the following customisations (presumably I need to use the word plugin):

I'd like the 'Limit' value to be shown as a line across the stacked bar chart - this is straightforward in the browser GUI, Chart Plot Area -> Series 1 Chart Type => Marker - but how do I set this from the bi publisher plugin in word?

Secondly, I'd like to colour the stacked graph according to the machine name, but not all machines would always be present in the report so I series x might not always be red etc.  So how would I do conditional formatting based on the value?