Create Custom Chart with 2 Axes Values in VBA

wira

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create new series (on the same chart) for every change of values in a combobox	uriel78	Charts and Charting in Excel	5	April 15th 05 12:08 AM
How do I create a "backwards" chart	Sarah	Charts and Charting in Excel	2	March 31st 05 05:08 AM
How do I create a pointer chart, like a speedometer?	Ricardo Kozlowski	Charts and Charting in Excel	2	March 31st 05 03:23 AM
How do I create a custom scroll bar on a 3D Pivot Chart?	JRW in Idaho	Charts and Charting in Excel	1	December 1st 04 08:55 PM
Chart newbie help, please, How to create	JohnT	Charts and Charting in Excel	3	November 30th 04 04:17 PM

All times are GMT +1. The time now is 08:47 AM.

Menu

About Us