excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Medium Priority · Version 2003

Clare has attended:
Excel Intermediate course

Excel

How are formulae easily displayed on charts?

RE: 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


 

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips


Server loaded in 0.09 secs.