using MSGraph.Chart.8 in vb

Marvinq · Joined: 04 Oct 2007 Posts: 6

very urgent, I need to be able to update msgraph.chart.8, also called
Microsoft Graph 2000 in visual basic. All of my efforts have failed.
I've searched the internet and found some references to using the
datasheet.range properties, but VB just gives me errors.

I've heard this can work with OLE. My backend is SQL. I need to
pass the query results to the chart somehow.

Can any of you geniuses out there show me a way to make it work?

Thanks
Marvin

Archived from group: microsoft>public>vb>ole

Steve Rindsberg · Joined: 04 Oct 2007 Posts: 20

In article , Marvinq
wrote:
> very urgent, I need to be able to update msgraph.chart.8, also called
> Microsoft Graph 2000 in visual basic. All of my efforts have failed.
> I've searched the internet and found some references to using the
> datasheet.range properties, but VB just gives me errors.
>
> I've heard this can work with OLE. My backend is SQL. I need to
> pass the query results to the chart somehow.

What chart, where?

MSGraph isn't a standalone app; its charts have to be hosted in another app --
Word, PowerPoint, even Wordpad. And to get AT the embedded chart, the app
would have to expose automation, so WordPad would be a nonstarter.

To pass data to a chart, you'd need to get a reference to the chart object in
the host document and through it, get access to MSGraph's methods/properties in
order to manipulate the chart.

Hint: get it working with Excel charts, then translate to MSGraph. The object
models are quite similar.

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Excel chart from VB to Excel Hi I've a Chart object in a VB6 form together with some text boxes, my question is can I "copy" the chart object from the form and place it in a Excel chart ?? I know I can create the chart in a Excel my question is can I

MSGraph.Chart OLE I have taken over a dll that uses an OLE to display data. After being distributed to clients, a handful have reported errors with the dll. I have found that the error occurs when trying to reference the chart in the dll. Since it only h

change data range of excel chart from vb Hi, I've created an VB6 App with a OLE Excel Chart object embedded. I'm trying to change the datarange of the chart. I need help!!!! This is my code: Dim wb As set wb = 'This is the OLE Excel chart With wb .Sheets("C

MSGraph question ... A family member ran into problems using MSGraph in a new Access 97 app that they were writing, so of course they called me in to figure it out. I called up the property page, but as usual there were lots of cryptic labels for things and no explanation as

What's wrong with MS Chart? Hi All I need to do a lot of chart work (ie pie charts, graphs, etc) in my vb6 app and I've noticed that quite a few don't use the built-in MS Chart component. Is there any reason? It seems to have all of the required but is there a hidden