MS Word Chart Coding (Urgent)

[vbnetdev]

My boss wants this done in a day. I would be happy with a week!

Anyway, I have a dataset filled with data and need to populate an MS word
chart with it. Any tutorials or suggestions would be great. I know a dataset
is a .NET concept but taking the chance people here might be familar with
it.

 

[Jonathan West]

My boss wants this done in a day. I would be happy with a week!

Anyway, I have a dataset filled with data and need to populate an MS word
chart with it. Any tutorials or suggestions would be great. I know a
dataset is a .NET concept but taking the chance people here might be
familar with it.

Export the dataset into a table of some kind. Paste the table into the data
table of the chart object you insert into Word.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[vbnetdev]

Do you know fo a tutorial on vba and charting in word I can research? this
woudl be a big help.

thanks for your help so far.

 

[Tony Jollans]

Charting in Word is done with MS Graph. I don't know of any tutorial for it
and I have found it very difficult (and resource hungry) working with it in
VBA. Better to create your chart in Excel and paste the result into Word.

I don't know anything about .NET - is a dataset in .NET somehow different
from a dataset anywhere else?

 

[Cindy M.]

Hi Vbnetdev,

Anyway, I have a dataset filled with data and need to populate an MS word
chart with it. Any tutorials or suggestions would be great. I know a dataset
is a .NET concept but taking the chance people here might be familar with
it.

I'm familiar with it...

First thing you have to decide is whether to use an Excel chart or MS Graph.
Both use the same "engine", but with Excel the data is embedded on a
spreadsheet in the OLE object, while with MS Graph you fill a "data sheet". MS
Graph also has a more limited object model; OTOH, the machine where you're
creating the chart doesn't have to have Excel installed.

On my website you'll find a bit of VBA code that illustrates how to generate a
chart from a set of data as part of a mail merge. This should give you the
basics for automating MS Graph. If you need more assistance, the better place
to get help would be the office.developer.automation newsgroup.
Http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#MrgChart

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

 

[vbnetdev]

Interesting question on the dataset.....

I suspect it is but I wouldn't know how.....