MS Word Chart Coding (Urgent)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vbnetdev - 05 Oct 2006 02:35 GMT

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.

Reply to this Message

Jonathan West - 05 Oct 2006 07:58 GMT

> 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.

Signature

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

Reply to this Message

vbnetdev - 05 Oct 2006 15:52 GMT

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.

>> My boss wants this done in a day. I would be happy with a week!
>>
[quoted text clipped - 5 lines]
> Export the dataset into a table of some kind. Paste the table into the
> data table of the chart object you insert into Word.

Reply to this Message

Tony Jollans - 05 Oct 2006 19:20 GMT

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?

--
Enjoy,
Tony

> Do you know fo a tutorial on vba and charting in word I can research? this
> woudl be a big help.
[quoted text clipped - 17 lines]
> > Please reply to the newsgroup
> > Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message

vbnetdev - 10 Oct 2006 23:31 GMT

Interesting question on the dataset.....

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

> Charting in Word is done with MS Graph. I don't know of any tutorial for
> it
[quoted text clipped - 32 lines]
>> > Please reply to the newsgroup
>> > Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message

Cindy M. - 09 Oct 2006 10:11 GMT

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 :-)

Reply to this Message