Code to interact with a chart's data

[Keven Denen]

Is anyone familiar with the code to interact with the datasheet that
is behind Word 2003's chart objects? I'm trying to export some data
from Access into a Word document. I use bookmarks in most places where
I need the data to be located, but I want to have a chart that is
built off some data from my Access database. Any tips/hints?

Keven Denen

 

[Cindy M.]

Hi Keven,

Is anyone familiar with the code to interact with the datasheet that
is behind Word 2003's chart objects? I'm trying to export some data
from Access into a Word document. I use bookmarks in most places where
I need the data to be located, but I want to have a chart that is
built off some data from my Access database

I'm a little familiar with it... The exact syntax depends, too, on
whether you're creating an Excel chart or an MS Graph chart.

For creating the new chart, record doing so in a VBA macro for the basic
syntax. If you copy that into a reply, we can see what kind of chart
you're using. From there, we can show you how to access the object
model, although we may not be able to help with the finer points of
creating a chart.

FWIW, both types of chart use the same engine (Excel's). But the MS
Graph object model doesn't support as rich a UI (you can't manipulate
text boxes, etc.) and incorporates its own DataSheet (since there's no
Excel worksheet to hold the data). OTOH, if a user doesn't have Excel
installed, he should at least have MS Graph.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail