Charts
 

I am writing a macro that creates charts. In order to control these charts
better I want to add them as chart objects. Therefore I write the code as
follwing:

Set chtChart = Charts.Add
With chtChart
.Name = "test chart"
.ChartType = xlUserDefined
.TypeName:="Standard"
The problem is that I do not use the standard charts in Excel but one type
that my firm uses. How do I write code so that the chart object is of correct
type?

Charts
 

Hi
See what the macro recorder does with your custom chart type.

regards
Paul

Fabrizio wrote:
I am writing a macro that creates charts. In order to control these charts
better I want to add them as chart objects. Therefore I write the code as
follwing:

Set chtChart = Charts.Add
With chtChart
.Name = "test chart"
.ChartType = xlUserDefined
.TypeName:="Standard"
The problem is that I do not use the standard charts in Excel but one type
that my firm uses. How do I write code so that the chart object is of correct
type?