Insert Cell Text Into Chart

[Karen]

I have a cell of text(on sheet 1) that I want to paste
into the top portion of a chart (on sheet 2) - I have done
this before, but I cannot remember how - HELP!

 

[Frank Kabel]

Hi
insert a textbox, select this textbox and enter the equation sign '='.
Now select your cell on sheet 1 and hit ENTER

 

[Guest]

Thank you for your help - I'm sorry, maybe I didn't
explain it well enough. I have a specific cell of text
that has a border around it that I want to insert into the
top portion of the chart. I clicked on the cell,
navigated to the chart, clicked on the chart and attempted
to paste it and it won't paste - HELP!

 

[Jon Peltier]

Karen -

Select the cell, hold Shift while selecting Copy Picture from the Edit
menu (I don't know which options work best with cells; I use on screen
and picture with charts). Select the chart and Paste.

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