[Progress Communities] [Progress OpenEdge ABL] Forum Post: Bar graph re-positioning in Excel using Progress

  • Thread starter Thread starter p_kambi
  • Start date Start date
Status
Not open for further replies.
P

p_kambi

Guest
Hi Community , We have utility developed in Progress which created data labels and bar graph in excel based on the input provided. However , currently the bar graph is positioned randomly in Excel , where we would like to position the bar graph in particular Row/cell in excel. Please find the below code snippet for your reference. /* 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(3 /* xlLocationAsObject = 2 */, "Detail":U). */ Any inputs/suggestion is appreciated. Regards, Kambi.

Continue reading...
 
Status
Not open for further replies.
Back
Top