Equation in a chart

[Manos]

Dear all

There is any possibility to add in the area of a chart a
box or a text box or another way and to make it with a
simple = to bring me a value of a cell? either a number
or a percentage?

I currently using Excel XP edition


Thanks in advance Manos

 

[Frank Kabel]

Hi
try the following:
- insert this textbox
- select the textbox and hit F (to get into the formula bar)
- now enter your formula. e.g.
='sheet1'!A1

 

[Manos]

thank you Frank it works perfectly

Regards Manos

 

[Jon Peltier]

For a simple textbox, all you need to do is select the chart and start
typing. Type '=' as your first character, then select the cell with the
mouse.

For a different text element (chart or axis titles, data labels), select
the element so it is highlighted by the gray rectangle but the cursor is
not within the text, type '=', and click on the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______