Charts by VBA

[Mikko Rantanen via OfficeKB.com]

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

 

[Word Heretic]

G'day "Mikko Rantanen via OfficeKB.com" <[email protected]>,

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:

 

[Cindy M -WordMVP-]

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 Rantanen via OfficeKB.com]

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

 

[Mikko Rantanen via OfficeKB.com]

hello

I have solved this problem whit dummy excel files.

regars
Mikko