Create Custom Chart with 2 Axes Values in VBA

[wira]

Hi there,

IF anyone here could show me how to create custom chart in VBA. I want to
create a combination of bar and line chart. What i know is to create a chart,
u need to

Dim chrt as Chart

Set chrt = ChartObjects.Add
chrt.ApplyCustomType(ChartType, TypeName)

I have a problem with the arguments there. Solution, anyone?

thanks,
wira

 

[Tushar Mehta]

Does XL give you the necessary code if you use the macro recorder?
Turn it on (Tools | Macro > Record new macro...), do whatever it is you
want by hand, turn off the recorder, switch to the VBE, and check the
code XL generated.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions