Equation in a chart

  • Thread starter Thread starter Manos
  • Start date Start date
M

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
 
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
 
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/
_______
 
Back
Top