Charts by VBA

Hi

I need to build two charts by vba.
Thats not so dificult, but how can I modify data in that chart.
Im using MSgraph but if someone has better ideas I take them gratefully.

Sub make_chart()

Selection.InlineShapes.AddOLEObject ClassType:="MSGraph.Chart.8", _
LinkToFile:=False, DisplayAsIcon:=False
End Sub

Regards Mikko

--
Message posted via http://www.officekb.com

Word
Fri Mar 18 06:52:00 CST 2005

G'day "Mikko Rantanen via OfficeKB.com" <forum@OfficeKB.com>,

Create a dummy file, populate with data, edit data, make graph.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Mikko Rantanen via OfficeKB.com reckoned:

>Hi
>
>I need to build two charts by vba.
>Thats not so dificult, but how can I modify data in that chart.
>Im using MSgraph but if someone has better ideas I take them gratefully.
>
>Sub make_chart()
>
> Selection.InlineShapes.AddOLEObject ClassType:="MSGraph.Chart.8", _
> LinkToFile:=False, DisplayAsIcon:=False
>End Sub
>
>Regards Mikko

Cindy
Sun Mar 27 10:05:50 CST 2005

Hi Mikko,

> Thats not so dificult, but how can I modify data in that chart.
>
Are you only so far that you can make the graph? Or have you
figured out how to automate MS Graph in any way? (IOW, I'm trying
to find out exactly where you're stuck...)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8
2004)
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 :-)

Mikko
Thu Apr 07 13:51:39 CDT 2005

Hi Cindy

I can create chart, Like this:

Sub make_chart()

Selection.InlineShapes.AddOLEObject ClassType:="MSGraph.Chart.8", _
LinkToFile:=False, DisplayAsIcon:=False
End Sub

But I can't do anything more... :<

I need to make a chart were is shown units / month, this and prev. year.
And I want to launch a form where user sets those units. And
(here come's the hard part, I think) I want to make this whit document
template. So user opens a template, a form asks reports details. After that
other form asks about values of that charts. When I do this in a template
there is no excel file to modify.

By the way, how can I set the template to be in report page (when choosing
template)

Mikko

--
Message posted via http://www.officekb.com

Mikko
Tue Apr 12 13:25:12 CDT 2005

hello

I have solved this problem whit dummy excel files.

regars
Mikko

--
Message posted via http://www.officekb.com