• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

MSGraph Automation

Hi Experts,

Does anyone know if it's possible to create an MSGraph object without the need for powerpoint and excel?

I am familiar with the MSGraph object itself and using it with PowerPoint and Excel but i would like to do something a little different.

My goal for now is to be able to create an MSGraph chart and display it on a form. Another problem i have is how to display it on a form. What control would i need?

The reason i cant get started is because you cannot create a New instance of the MSGraph application and Chart objects in VB.Net.

Any help would be much appreciated.

Cheers,

Tom
0
TommyTwoPints
Asked:
TommyTwoPints
1 Solution
 
SanclerCommented:
>>
you cannot create a New instance of the MSGraph application and Chart objects in VB.Net.
<<

I'm not sure that it's what you want, but if you add a .Com reference to Microsoft Office Chart - whichever version/s you have - you should be able to drag it from the Components Tag on the Toolbox onto a form.  You are then given the option to select a datasource or hardcode values and choose a variety of graph/chart files with the Active-X Edit command at the bottom of the properties window.

I've only ever used it (Version 10, in VB.NET 2003) for a "picture", so have no experience of dynamic coding with it.  But I wondered if it might help you.

Roger
0
 
TommyTwoPintsAuthor Commented:
Hi Roger,

That is excellent; just what i need,

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now