Select the chart title (or axis title, data label, or shape). You don't need
to click in the formula bar first, but it might make it easier to see what
you're doing, the first time or two. So click in the formula bar, type the
equals sign, then click on the target cell (the formula bar should now
contain an address like =Sheet1!$A$1) and press Enter.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Hankjam" ........ wrote in message
...
Hi
So all the help buttons say "insert an '=' into the formula line and
then hit the target cell and enter".
I must be doing something real wrong as it doesn't work for me..
that or I'm a diddie doing something way wrong.
Thanks for your time.
Aj