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 Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Graphs/Charts



 
 
Thread Tools Display Modes
  #1  
Old June 22nd, 2004, 05:18 PM
external usenet poster
 
Posts: n/a
Default Graphs/Charts

How to link graphs in Word with Excel spreadsheets.
  #2  
Old June 22nd, 2004, 09:19 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default Graphs/Charts

There is no way that would not be a lot more trouble than pressing Ctrl+End
or Shift+F5. You can record a macro to do either of those and name it
AutoOpen, which will make it run when you open the document. The problem is
that, if you save the macro in the document, you'll have extra clicks
because you'll get a macro warning and have to answer it. And if you save
the macro in Normal.dot, it will affect every document you open--probably
not what you want.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

wrote in message
...
How to link graphs in Word with Excel spreadsheets.


  #3  
Old June 22nd, 2004, 10:27 PM
garfield-n-odie
external usenet poster
 
Posts: n/a
Default Graphs/Charts

In Excel, select the graph and press Ctrl+C to copy it to the Windows clipboard. Switch to Word. Click on the place in the Word document where you want the Excel graph to be inserted. Click on Edit | Paste Special | Paste link: Excel object.


" wrote:

How to link graphs in Word with Excel spreadsheets.

  #4  
Old June 22nd, 2004, 11:14 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default Graphs/Charts

Whoops, this was posted to the wrong thread!

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Suzanne S. Barnhill" wrote in message
...
There is no way that would not be a lot more trouble than pressing

Ctrl+End
or Shift+F5. You can record a macro to do either of those and name it
AutoOpen, which will make it run when you open the document. The problem

is
that, if you save the macro in the document, you'll have extra clicks
because you'll get a macro warning and have to answer it. And if you save
the macro in Normal.dot, it will affect every document you open--probably
not what you want.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup

so
all may benefit.

wrote in message
...
How to link graphs in Word with Excel spreadsheets.



 




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 03:45 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.