Excel Charts - Text Box Problem

[tpearo]

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]

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