RE: MS Word Chart filled with data - URGENT PLEASE

Hi,

Here I understand that you means the Chart that using Word Menu,
Insert/Picture/Chart.
So I think you may try to transfer the DataSet to a Excel Workbook and then
import the excel file into the Chart.

Here is a VBA macro for your reference, but it is easy to run the similar
code in VB.NET.

Sub Macro1()
Dim oChart As Graph.Chart 'Add reference to Graph Object library
Set oChart =
Selection.InlineShapes.AddOLEObject(ClassType:="MSGraph.Chart.8",
LinkToFile:=False, DisplayAsIcon:=False).OLEFormat.Object
oChart.Application.FileImport "C:\temp\TestABC.xls"
End Sub

How to automate Word from Visual Basic .NET to create a new document
http://support.microsoft.com/default.aspx?scid=kb;[LN];316383

How to automate Microsoft Word to perform a mail merge from Visual Basic
NET
http://support.microsoft.com/default.aspx?scid=kb;[LN];302816

How to automate Microsoft Word to perform a mail merge from Visual Basic
NET
http://support.microsoft.com/default.aspx?scid=kb;[LN];301656

Here is a link about how to transfer data into Excel Workbook in VB.NET.
How to transfer data to an Excel workbook by using Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;[LN];306022

You may have a try and let me know the result.

If I misunderstood or you have any conern on this issue, please feel free
to let me know and I am glad to be of assistance.


Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: MS Word Chart filled with data - URGENT PLEASE
    ... Can you possibly demonstrate in the Set oChart statement the use of a ... Here I understand that you means the Chart that using Word Menu, ... How to automate Microsoft Word to perform a mail merge from Visual Basic ... Here is a link about how to transfer data into Excel Workbook in VB.NET. ...
    (microsoft.public.dotnet.languages.vb)
  • Can the owc11 warnings be disabled?
    ... I have embedded the owc11 pivot table and chart in an Excel workbook. ... connection works fine and I am able to write code to capture events ...
    (microsoft.public.office.developer.web.components)
  • Re: Linking to simple data entry
    ... With that saved create a PPT file in the same folder as the workbook. ... Copy each XL chart and Paste Special Link as Excel workbook into PPT. ...
    (microsoft.public.powerpoint)
  • Re: Displaying Multiple Excel files, Not plotting zero values
    ... Apply an AutoFilter to the list (Custom, does not equal zero), and the chart will show only the non-zero values. ... I open more than one Excel workbook, I want to display them side by side to make some comparisons. ... I want to only display non-zero values. ...
    (microsoft.public.excel)
  • Linked Excel Charts/PowerPoint
    ... 4 data sheets which link to 4 different charts. ... individual slides in PPT with links, close Excel, switch ... chart 3) is the only chart ... chart in it's own Excel workbook? ...
    (microsoft.public.powerpoint)
Loading