MSExcel Automation - Custom ChartType

[torturedmind]

Hi.

I have this problem in MS Excel automation and it's been a week since I've been stuck with this. I can't seem to find any reference on the custom ChartType Line - Column on 2 Axes. All I know is the numeric value for custom ChartType which I got from this page. Can anyone help me set my ChartType property to "Custom, Line - Column on 2 axes" type?

TIA

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[Koen Piller]

Hi,

I would post this in a MSOffice forum, however if you would like to built a graph in VFP I would advise you to make use of FoxGaph, much more elaborate graphs than Excel.


Regards,

Jockey (2)

 

[torturedmind]

@Jockey

If you mean FoxCharts then yes, am already using it with VFP9. But if you mean FoxGraph of FP2.6 then am sorry but we don't have FP2.6 in any of our development boxes. Also, the application am trying to modify is made under VFP6 as most apps here are made under this version. Anyways, thanks for the suggestion. I'll try to get some answers from the MSOffice forum.

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[Olaf Doschke]

In general, if you want to know how something is done in Excel do it in Excel while recording a macro there. You can find out used code and constants within the recorded macro.

Bye, Olaf.