Excel Charts - Text Box Problem
 

I have several Excel charts that I am working on for a presentation. I
plan on using Powerpoint for the presentation but am creating the
charts in Excel.
One problem that I am having is that I have a text box that I have
placed on my chart below the title - I need to copy the entire chart so
that I can paste it into Powerpoint but when I click on the chart to
copy.... the text box disappears. I've tried sending the chart to
back.... the funny thing is if I copy the text box to another cell and
paste it.... then copy it back on to the chart it seems to stay. What's
that all about.

Any help would be appreciated.

Tp


--
tpearo
------------------------------------------------------------------------
tpearo's Profile: http://www.excelforum.com/member.php...o&userid=35629
View this thread: http://www.excelforum.com/showthread...hreadid=554097

Excel Charts - Text Box Problem
 

Hi,

The textbox needs to be embedded within the chartobject.
Select the textbox and cut CTRL+X
Select the chartobject and paste CTRL+V

the textbox should now be bound within the chartobject rather than
floating on the drawing layer.

Cheers
Andy

tpearo wrote:
I have several Excel charts that I am working on for a presentation. I
plan on using Powerpoint for the presentation but am creating the
charts in Excel.
One problem that I am having is that I have a text box that I have
placed on my chart below the title - I need to copy the entire chart so
that I can paste it into Powerpoint but when I click on the chart to
copy.... the text box disappears. I've tried sending the chart to
back.... the funny thing is if I copy the text box to another cell and
paste it.... then copy it back on to the chart it seems to stay. What's
that all about.

Any help would be appreciated.

Tp



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info