Chart position in excel using Progress 4GL

Posted by p_kambi on 14-Mar-2019 07:16

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. 

All Replies

This thread is closed