Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert text table in excel spreadsheet | Excel Worksheet Functions | |||
How do I insert a symbol AT THE END of text for multiple cells in Excel? | Excel Worksheet Functions | |||
Text box in chart disappears but reappears when in spreadsheet | Charts and Charting in Excel | |||
How do I insert a symbol BEFORE text for multiple cells in Excel? | Excel Worksheet Functions | |||
insert text in a no. of cells of each sheet? | Excel Discussion (Misc queries) |