>I have dug down into the help file for MSGraph 9, and I have found this
>
>MajorUnitScale Property
>Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Can be one of the following XlTimeUnit constants: xlDays, xlMonths, or xlYears. Read/write Long.
>
>I have searched the MSDN and every file on my harddrive for a reference to xlMonth. Does anyone know where I can find the new msgraph.h that contains these new constants?
>
>TIA,
>
>Tracy

You can find these on the Excel constants. There are a couple of downloads here in the UT, one for the Excel 97 constants: http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1005 and one to get the constants from any COM server: http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1053