Information générale
Catégorie:
COM/DCOM et OLE Automation
>Hello all
>
>I am going to put graphs into my program, I download the following from UT (I think) I am looking for the possible variables for the msgraph.chart class i.e. graphtype, show totals yada yada
>or do I do that through a olebound control and if so then where can I get a list of those variables?
>
>Thanks
>
>Stephen McLaughlin
>"Blastmaster"
>stephenmclaughlin@email.com
>
I am using an olebound object to work with my graphs. I usually start with a hidden form and add the object to it with the controlsource being my general field holding the graph. This general field can be in a physical table or in a temporary view, I am using both in one of my applications. For a list of all objects, properties, collections and so forth look for a file called VBAGRP9.CHM in your "Program Files\Office" directories. (This is the one shipped with Office 2000.) This will give you all of the constants that are available in office. You can use Excel and VBA to get the values of theses constants. (I am still looking for a header file with all of them listed.) Here is an example VBA Macro to list the values for all of the "Column" chart types.
Sub Constant()
Sheet1.Cells(1, 1).Value = xlColumnClustered
Sheet1.Cells(2, 1).Value = xl3DColumnClustered
Sheet1.Cells(3, 1).Value = xlColumnStacked
Sheet1.Cells(4, 1).Value = xl3DColumnStacked
Sheet1.Cells(5, 1).Value = xlColumnStacked100
Sheet1.Cells(6, 1).Value = xl3DColumnStacked100
Sheet1.Cells(7, 1).Value = xl3DColumn
End Sub
Good Luck.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement