Hi Community ,
We have developed the code to generate the bar graph in excel using progress , however we are facing the problem while placing the graph in particular location/range in excel , when we generate multiple bar graphs they overlap at the same position.
Here is the code snipped that we have used:
chChart = chWorkBook:Charts:Add()
chChart:ChartType = 57 /* xlBarClustered = 57 */
chChart:HasTitle = TRUE.
chChart:ChartTitle:Characters:Text = hold-mem.
chChart:SetSourceData(chWorkSheet:Range(vRangeSource)).
chChart:ApplyDataLabels(5 /* xlDataLabelsShowLabelAndPercent = 5 */).
chChart:Location(2 /* xlLocationAsObject = 2 */, "Detail":U).
Please give your answers/suggestion to place the graphs in particular range.
Any help is appreciated !
Thanks,
Kambi.