Chart title reference a cell

F

Frank Kabel

Hi
try the following
- select the title textbox
- enter the equation sign '='
- select the cell to reference
 
C

Circe

Tried it. That just adds the text =celladdress
-----Original Message-----
Hi
try the following
- select the title textbox
- enter the equation sign '='
- select the cell to reference

--
Regards
Frank Kabel
Frankfurt, Germany



.
 
F

Frank Kabel

Hi
try the following (sorry forgot one step):
- select the textbox
- hit F2 or manually click in the formula bar
- now insert the cell reference with equation sign
 
J

Jon Peltier

Actually, that step isn't necessary, if the title box is selected
without activating the cursor within it.

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