Graph

[Norbert Meiss]

I would like to force a graph in Access 2003 to plot by columns instead of
rows and get an error 438 in the line "PlotBy...". What do I miss?

Dim objchart As Graph.Chart
Set objchart = Me.objGraph.Object
With objchart
.PlotBy = xlColumns
.ChartType = xl3DArea
.PlotArea.Border.LineStyle = xlSolid
.ChartArea.Border.LineStyle = xlSolid
...
End with

TIA,
Norbert Meiss

 

[Andy Pope]

Hi,

PlotBy is a property of the Application rather than the Chart object.

Dim objGraph As Graph.Application

Set objGraph =
ActivePresentation.Slides(1).Shapes(1).OLEFormat.Object.Application
objGraph.PlotBy = xlColumns

Cheers
Andy

 

[Norbert Meiss]

Hi,

this code doesnt't work in Access 2003 Code behind form (error 429, object
creation not possible in line Set objGraph = ). I wonder how to set the
reference to the Microsoft Graph Chart in my form.

TIA, Norbert

 

[Andy Pope]

If your referencing is working maybe using the Parent property will do it.

Dim objchart As Graph.Chart
Set objchart = Me.objGraph.Object
With objchart
.Parent.PlotBy = xlColumns


Cheers
Andy

 

[Edgar]

Hello Tia,

I'm trying to manage the graph chart in Access, but I don not have it
possible.
The me... object, in this case a Report do not have the graph.chart object
within its hierarchy. How could you find it? any comment woul be appreciated

Thanks