Excel

Hi Claire,

Thank you for your question.

As far as I am concerned you can only copy and paste formulas from a sheet containing figures. Alternatively, you could create a text box on the chart and write the formula directly into it.

You could copy and paste the formula from the formula bar, or use the Insert Object Command, choose Equation Editor and produce a more complicated formula. Once complete, copy and paste the object on to the chart.

I will keep looking and if I do find another way of doing it, I will contact you again.

I hope this answers your question.

Regards

Simon