Thanks heaps for your help. It ended up that the equation
wasn't changing because I was an idiot and changed the
font making the chart think that it was now a textbox and
so wasn't updating the data. Great! Thanks again!

Kathy