Hi Guy's
Thanks to all who have replied.
I see that you mentioned in my profile I am using Excel 2002. I am working between 3 different computers and have noticed that I switching between 2002,2003 and Mac2011, I take it all these versions make a difference?
I have went with the following formulas and they seem to work however I better check on all 3 versions.
In cells C9:O9 they have
and in P9
I have noticed though it has caused the Graph to report a graph line of zero's where it is pulling the information from C9:O9 is there a way round this?
I have attached the up to date example to let you see.
Bookmarks