MSGraph Help File?

  • Thread starter Thread starter Alan Z. Scharf
  • Start date Start date
A

Alan Z. Scharf

Is there an MSGraph help file anywhere in an Office 11 installation?

Thanks.

Alan
 
Hi Alan,

A good way to get help is to use the Object Browser

from the design view of any module, make a reference to to
the Graph Library

from the menu --> Tools, References
check Microsoft Graph #.# Object Library

*** launch the Object Browser ***

from the menu --> View, Object Browser
OR
F2

On the left, you will probably see a Project window and a
Properties window below it
On the right, you will see the main Object Browser window

change <All Libraries> in the Project/Library combobox in
the upper left of the Object Browser window
to
Graph

explore each object in Classes
as you select a Class on the left, its members will appear
in the pane on the right

when you see something you want help on, PRESS THE F1 KEY
and switch to the Help window

You will see that Point is one of the classes you can choose
-- and you can see all the properties for the point object
listed on the right

for instance,

1. choose "Point" from Classes
2. click on the "DataLabel" property on the right
3. press the F1 key

here is an example from help on using the DataLabel
property, which is ReadOnly:

Code:


With myChart.SeriesCollection(3).Points(7)
.HasDataLabel = True
.ApplyDataLabels type:=xlValue
.DataLabel.Font.ColorIndex = 5
End With


The Object Browser gives you a way to explore what is
available to you as you write code to act on MS Graph objects.


Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
Another method for figuring out code for graphs is to create a basic graph
in MS Excel. Then turn on the macro record and make modifications to the
graph that resemble what you would like to do in Access. Then stop the
recorder and view the code.

You can generally copy and paste the code into Access and make a few
modifications.
 
Back
Top