how to make language independent a chart application

[cghersi]

Hi, I'm facing up with this problem:

I wrote an application which dinamically creates a chart via VBA.
This chart MUST be built in this way:

Set costChart = ActiveSheet.ChartObjects.Add(Left:=50, Width:=800,
Top:=30, Height:=400)
costChart.chart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="Line
- Column"


now, the problem is that the application must be language independent,
and in other languages different from English, the TypeName "Line -
Column" is not understood.
The kind of graph is mandatory (from customer specification), so I
must use ChartType:=xlBuiltIn and TypeName:="Line - Column".

A possible solution that I'm thinking about is to save this kind of
graph as User-Defined with a proper name, but the point is that I have
to save these information INSIDE the workbook, because the application
must consist in a single Excel file, and I don't know how...

how can I do?

thank u very much

 

[cghersi]

Hi, I'm facing up with this problem:

I wrote an application which dinamically creates a chart via VBA.
This chart MUST be built in this way:

Set costChart = ActiveSheet.ChartObjects.Add(Left:=50, Width:=800,
Top:=30, Height:=400)
costChart.chart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="Line
- Column"

now, the problem is that the application must be language independent,
and in other languages different from English, the TypeName "Line -
Column" is not understood.
The kind of graph is mandatory (from customer specification), so I
must use ChartType:=xlBuiltIn and TypeName:="Line - Column".

A possible solution that I'm thinking about is to save this kind of
graph as User-Defined with a proper name, but the point is that I have
to save these information INSIDE the workbook, because the application
must consist in a single Excel file, and I don't know how...

how can I do?

thank u very much

I've done: chartType= xlColumnClustered

add a trendline to a hidden series