G
Guest
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?
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?