Cool, I know where I went wrong now, I can't thank you all enough.

I have just been told I can ditch some of the unused data from the worksheet, but need to add in a 5th coordinate figure, which is an result figure, I have redesigned the sheet and got the graph to plot as "Andy" has done.

I now have a new problem. is there anyway I can hide a series of plots depending on a cell value is empty? ie, no number in a cell, then the series doesnt get shown,

I am assuming this has to be done using a IF statement or will it have to be done via a macro?

If it can be done using a IF statment, at which part of the worksheet does it need to go in?