Create Custom Chart with 2 Axes Values in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top