A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Make Text Part of Chart



 
 
Thread Tools Display Modes
  #1  
Old March 11th, 2004, 07:38 PM
Alex
external usenet poster
 
Posts: n/a
Default Make Text Part of Chart

I want to make a text box part of a chart. I know how to
add text to a chart with a text box, but then it
disappears when I click on the chart to copy it. It also
moves when I resize a chart, and I would like the text to
stay where it is relative to my placement.

Is there an add-in for the feature, or am I up a creek
without a paddle?

thanks.
  #2  
Old March 11th, 2004, 09:09 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Make Text Part of Chart

Select the chart, and type the text you want to appear on the chart.

As you type, you'll see the text in the formula bar.
Press Enter, and a text box will appear near the centre of the chart.
Drag it to any location within the chart, and format as required.

Alex wrote:
I want to make a text box part of a chart. I know how to
add text to a chart with a text box, but then it
disappears when I click on the chart to copy it. It also
moves when I resize a chart, and I would like the text to
stay where it is relative to my placement.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3  
Old March 11th, 2004, 09:20 PM
external usenet poster
 
Posts: n/a
Default Make Text Part of Chart

OK I got that part. But now if I click on the chart to
copy it, the text box disappears and does not copy. I
also encounter the problem that if I resize the chart, the
text box does not move with the chart and I have a long
task of moving the items. (By the way, when I mention
text, I mean more than one comment on the graph and
numerous other little add-ons.

Thanks, but my question has to do with management instead
of creation.
-----Original Message-----
Select the chart, and type the text you want to appear on

the chart.

As you type, you'll see the text in the formula bar.
Press Enter, and a text box will appear near the centre

of the chart.
Drag it to any location within the chart, and format as

required.

Alex wrote:
I want to make a text box part of a chart. I know how

to
add text to a chart with a text box, but then it
disappears when I click on the chart to copy it. It

also
moves when I resize a chart, and I would like the text

to
stay where it is relative to my placement.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

  #4  
Old March 11th, 2004, 09:29 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Make Text Part of Chart

If the text disappears when you select the chart, you didn't have the
chart selected when you created the text box.

Click on the chart first, to select it. You'll see handles on the
corners and sides of the chart.

Then, type the text, and press enter, to create the text box.

wrote:
OK I got that part. But now if I click on the chart to
copy it, the text box disappears and does not copy. I
also encounter the problem that if I resize the chart, the
text box does not move with the chart and I have a long
task of moving the items. (By the way, when I mention
text, I mean more than one comment on the graph and
numerous other little add-ons.

Thanks, but my question has to do with management instead
of creation.

-----Original Message-----
Select the chart, and type the text you want to appear on


the chart.

As you type, you'll see the text in the formula bar.
Press Enter, and a text box will appear near the centre


of the chart.

Drag it to any location within the chart, and format as


required.

Alex wrote:

I want to make a text box part of a chart. I know how


to

add text to a chart with a text box, but then it
disappears when I click on the chart to copy it. It


also

moves when I resize a chart, and I would like the text


to

stay where it is relative to my placement.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.