How to apply the custom chart type: "Line - Column on 2 Axes"

T

talrs

Hi,

As I wrote in earlier question I recently automated an Excel app to show
some statistics from a different program I’m currently working on.
One obstacle I still couldn’t pass was the custom type: "Line - Column on 2
Axes" chart.
Using the macro VBA recorder I got the following code:
Sub Macro1()
ActiveChart.SeriesCollection(2).Select
ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:= _
"Line - Column on 2 Axes"
End Sub
Which I translated to C++ code as:
chart -> ApplyCustomType ( (XlChartType)xlBuiltIn, "Line - Column on 2 Axes"
);
The result was as in previous attempts the default chart type in the user
defined custom types.
As much as I looked for I couldn’t find any reference to "Line - Column on
2 Axes" TypeName in the excel.tlh or .tli or using the OLE/COM object viewer.
Or a function that can get an “XlChartGallery†enum as the chart type
parameter rather then the XlChartType.

I’m sure that if the VBA can do it then there is a way to automate it in
C++, please let me know how:)

Thanks
Tal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Error when using Chart Line - Column on 2 Axes in vba code 2
Creating charts in non-English versions of Excel 11
Custom chart types; Recorded macro acts strange 4
"Lines on 2 Axes" fails on Excel 2007 1
Setting the colour of the legends in chart. 0
Column Chart with two axes 4
TypeName:="Line - Stacked Column on 2 Axes" ??? 2
Chart error 2

Top