Thanks for the reply,
I did and it works great, struggled with implementing it to fit the 21 conditions i have though, edited your example to accommodate numbers above 100 (as im not dealing with percentages) but this can be unmanageable when dealing with numbers that run into the thousands, which is why i need some if statements
eg if val < 10 then only draw graph up to the less than 10 mark, if val > 200 then draw the full chart