Insert spreadsheet cells into text box in a chart
 

Is it possible to insert data (A25:B30) from a spreadsheet into a text box in
a chart? Can someone give guidance on how to accomplish this.
Thanks in advance.
cb

Insert spreadsheet cells into text box in a chart
 

BTW, I am using 2007.

"CB" wrote:

Is it possible to insert data (A25:B30) from a spreadsheet into a text box in
a chart? Can someone give guidance on how to accomplish this.
Thanks in advance.
cb

Insert spreadsheet cells into text box in a chart
 

Select the range, go to Paste on the main tab but click the down arrow
thingie on the Paste button, choose As Picture, Copy as Picture. (See how
cleverly they hid Copy as Picture on the Paste button? Nobody can find it!)
Then select the chart and paste, to get a picture of the range. This is
merely a static picture, and will not update when the range changes.

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


"CB" wrote in message
...
BTW, I am using 2007.

"CB" wrote:

Is it possible to insert data (A25:B30) from a spreadsheet into a text
box in
a chart? Can someone give guidance on how to accomplish this.
Thanks in advance.
cb

Insert spreadsheet cells into text box in a chart
 

Jon,
Thanks so much for your help. This works just fine.
CB

"Jon Peltier" wrote:

Select the range, go to Paste on the main tab but click the down arrow
thingie on the Paste button, choose As Picture, Copy as Picture. (See how
cleverly they hid Copy as Picture on the Paste button? Nobody can find it!)
Then select the chart and paste, to get a picture of the range. This is
merely a static picture, and will not update when the range changes.

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


"CB" wrote in message
...
BTW, I am using 2007.

"CB" wrote:

Is it possible to insert data (A25:B30) from a spreadsheet into a text
box in
a chart? Can someone give guidance on how to accomplish this.
Thanks in advance.
cb