Hi Fellas,

Sorry it has taken me so long to acknowledge your emails - I have been away from work, unwell.

Unfortunately we haven't had a lot of luck with the getting the macro to work. It seems that the it does actually run, but the way that the pivot table selects the datapoints for plotting doesn't seem to lock the conditional formatting to the point being plotted (if that makes sense?!).

We have managed a slightly cumbersome work around... By adding a third page to the workbook, so that we have "raw data", "selected data" and the "table/graph page". So I now have to run the macro to get the graph to update at all, but a least it is showing all the data with the correct colouration now.

If you have any further suggestions, I'd love to hear from you.

My apologies again taking so long to reply.

Many thanks, MD.