DivisionsPerTick/MsGraph in Access

[Daveyk01]

I can find plent of references to using the Microsoft Chart Active-X on the internet.

I can find very little information on MsGraph objects. I actually control them rather well through VBA (i.e., Graph_Data.axes(2).minimumscale = MinScale(((Val(Me.ProbeLowestRespoce)) - 5) - ((Val(Me.ProbeAverageResponce))))
)

It's funny that the example statment only works with axes spelled incorrectly!

What I would like to do, if I load larger amounts of data is change the tick marker to the equivelent to "divisionspertick=2". That is a MSChart control, which I think is different from MSGraph.

In Chart, the following statement is, apparently, correct: .Plot.Axis(1).CategoryScale.DivisionsPerTick = 2, but doesn't work with MSGraph.

Does anyone here know the correct VBA commands for an MSGraph object? Is there a list, somewhere, of all available parameters that can be modified programmically?

Thanks

 

[Daveyk01]

Another desparate plee that I eventually figured out myself. I sure wish there was a list of all property functions that I could find for MSGraph.

'
If Me.ProbeNumElements <= 32 Then
Graph_Data.axes(1).ticklabelspacing = 1
Graph_Data2.axes(1).ticklabelspacing = 1
ElseIf Me.ProbeNumElements > 32 Then
Graph_Data.axes(1).ticklabelspacing = 2
Graph_Data2.axes(1).ticklabelspacing = 2
End If
'

What is the major difference between MSGraph and MSCHart? Does anyone have an opinion on which is better or more appropriate? Except for lasck of documentation and not list of the minor properties (as above) I've found Graph quite nice and easy to use for some rather complex charts. In one project recently, I did run in to a limitation of, I think, 4096 data points. Is you were trying to emulate a temperature graph with a one month history that may be a problem, but it is also awfull slow when you get a huge amount of points.