Change from a Vertical (Column) barchart to a horizontal (Clustered) barchart

I have created a Barchart using DXL (see below). Now I need change from a Vertical (Column) Barchart to a horizontal (Clustered) Barchart.

 //Add a column chart for the selected range
 oleGet(objWorkBook ,"Charts", objCharts )
 oleMethod(objCharts , "Add")
 oleGet(objWorkBook ,"Activechart", objActvChart )
 OleAutoObj objChartTitle

 put(AutoArgs, 1)
 oleMethod(objActvChart, "SeriesCollection", AutoArgs, objSeriesCollection)
 name = "Teams Assigned to project"

 olePut(objSeriesCollection , "Name", " Requirements" )
 oleGet(objActvChart, "SeriesCollection",  objSeriesCollection)
 objSeries = getSeriesItemFromCollection(objSeriesCollection, seriesNumber)

 oleMethod(objSeries, "Select")
 oleMethod(objSeries, "ApplyDataLabels")

.

.
.

However when I execute the following code, the Column Barchart does not change to a Clustered Barchart. What is wrong with my DXL OLE (oleGet, oleMethod, oldPut, etc) commands?

 


sjc2018 - Mon Jan 14 23:55:42 EST 2019

Re: Change from a Vertical (Column) barchart to a horizontal (Clustered) barchart
sjc2018 - Wed Jan 23 09:42:48 EST 2019

To All:

With help, I was able to write the DXL code to change from a Vertical Barchart to a Horizontal Barchart.  Here it is:

 

 int chartTypeInt
 oleGet(objActvChart, "ChartType", chartTypeInt)
 chartTypeInt = 57    //57 = xlColumnClustered Chart
 olePut(objActvChart, "ChartType", chartTypeInt)

 

It is simple as that.

Best of luck with your DXL scripting.