VBA, How to create a graph(chart) on a Word Document

How to create a graph(chart) on a Word Document

Author	Message
Elisha A.Phili #1 / 5	How to create a graph(chart) on a Word Document Hi, I am trying to create a graph(chart) on a Word document.This graph should be able to get its data from a table on this word document or from a Access database(from which i got the table on the word document,using "Insertdatabase" procedure,through VB). If anybody knows how to do this,please let me now. Any help will be greatly appreciated.Thanks
Tue, 12 Feb 2002 03:00:00 GMT

Cindy Meister -WordMVP #2 / 5	How to create a graph(chart) on a Word Document Hi Elisha, Quote: > I am trying to create a graph(chart) on a Word document.This graph > should be able to get its data from a table on this word document or from a > Access database(from which i got the table on the word document,using > "Insertdatabase" procedure,through VB). If anybody knows how to do > this,please let me now. I'm afraid there is no easy way to do this. You can create a MSGraph that is dynamically linked to a table in Word by copying the table's contents, starting MSGraph, and using the Eidt/PasteLink command from MSGraph's menu. This won't work with a table dynamically linked to an outside appication, however, because when the field that generates the table is updated the bookmark used by the Graph to identify the data is destroyed. A possible workaround would be VBA code that: 1) determines the bookmark location and name; 2) updates the table data; 3) restores the bookmark exactly. Cindy Meister INTER-Solutions, Switzerland http://ourworld.compuserve.com/homepages/cindymeister http://go.compuserve.com/MSWord This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
Wed, 13 Feb 2002 03:00:00 GMT

Cindy Meister -WordMVP #3 / 5	How to create a graph(chart) on a Word Document Hi Suzanne, Quote: > You can also copy and paste table cells from Excel into the data > sheet, so I assume you could do so from Access as well. No, this is not possible. An Access table only looks like an Excel worksheet - the internal structure is competely different :-) Cindy Meister INTER-Solutions, Switzerland http://ourworld.compuserve.com/homepages/cindymeister http://go.compuserve.com/MSWord This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
Wed, 13 Feb 2002 03:00:00 GMT

Suzanne S. Barnhil #4 / 5	How to create a graph(chart) on a Word Document Oh. Okay. Thanks. At least in researching this one I found out that MSGraph wasn't working and figured how to (I hope) get it functional again. Stayed awake last night wondering if Equation Editor was hosed as well. (It's apparently not, thank goodness!) -- Suzanne S. Barnhill Microsoft Word MVP Words into Type Fairhope, AL USA Quote: > Hi Suzanne, > > You can also copy and paste table cells from Excel into the data > > sheet, so I assume you could do so from Access as well. > No, this is not possible. An Access table only looks like an Excel > worksheet - the internal structure is competely different :-) > Cindy Meister > INTER-Solutions, Switzerland > http://ourworld.compuserve.com/homepages/cindymeister > http://go.compuserve.com/MSWord > This reply is posted in the Newsgroup; please post any follow question > or reply in the newsgroup and not by e-mail :-)
Wed, 13 Feb 2002 03:00:00 GMT

Cindy Meister -WordMVP #5 / 5	How to create a graph(chart) on a Word Document Hi Suzanne, Yuck. I know those kinds of nights... My big internal "bump" right now is whether to try installing NT Server on a machine <sigh> Quote: > Stayed awake last night -- Cindy
Thu, 14 Feb 2002 03:00:00 GMT

Page 1 of 1

[ 5 post ]