I have discovered that the problem is not with the lookup part of the formula itself, its a problem with the part of the formula that allow for the facility to only display data if it exits.

It doesn't like 'IF' no data exists, display "" (empty cell). If I repace it with 'IF no data exists, display 0, the data is displayed correctly on the graph.

This isn't ideal but it's progress!

I've attached a trail sheet to show what I'm talking about. Hope it helps!

Thanks

Attached Files

Book1.xls (30.5 KB, 11 views)