code to use excel chart thru foxpro 6

[HERVEC1]

Where I can find the list of code to define an excel chart thru foxpro

ex:

oXLChart1.application.charts[1].haslegend = .F.
oXLChart1.application.visible = .T.
oXLChart1.application.charts[1].autoformat(4,1)

how can I put a title in my chart ?
how can I change the font ?

thanks

 

[Mike Gagnon]

HERVEC1

Take a look at Thread184-281652 which you participated in and the suggestion is there.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[HERVEC1]

excuse me but I didn't understand

where I can find the VFP's "solutions".

I try to find out all information about the code I need to define an excel chart thru foxpro (like the title, the color, the legend etc...) thanks

 

[Mike Gagnon]

excuse me but I didn't understand

where I can find the VFP's "solutions".

In VFP6.0

D:\Program Files\Microsoft Visual Studio\MSDN98\98VS\1033
\SAMPLES\VFP98\Solution

In VFP7.0:

D:\Program Files\VFP7\Samples\Solution Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first or check this link

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[HERVEC1]

thanks but i found() the info for the title but i need
to change the backcolor , the font (i try : oXLchart1.application.charts[1].charttitle.Fontsize = 6
but i doens't work)

the color of the chart ....

and i did'nt find these informations in VFP solution

thanks HC

 

[Mike Gagnon]

HC

the color of the chart ....

Have you tried recording a macro in excel and changing the color of the chart and looking at the macro? It VB code but the property of the chart color would be the same in VFP, and the same goes for the chart title.
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first or check this link

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[HERVEC1]

I'm not an expert in excel and I think I cannot make a good macro !! thanks

 

[Mike Gagnon]

HerveC1

If you have Microsoft Office 2002 (XP) the help file that list all the objects and properties is located in :
C:\Program Files\Microsoft Office\Office10\1033\VBAXL10.chm
Or on the internet, this link might help:

http://msdn.microsoft.com/library/en-us/office97/html/web/fulltoc.asp

(chapter 4) Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.