Thread: Create Custom Chart with 2 Axes Values in VBA

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

In article <D86400EA-D0B9-4042-9225-7F10E5F435C2@microsoft.com>,
wira@discussions.microsoft.com says...
> 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
>