Excel Charts in Navision Classic

i am using “Microsoft Excel 12.0 Object Library” automation server to generate excel charts in navision classic

i am using xlChart.ChartWizard(xlRange,2,7,1,1,0,0,‘title’); function, how can i control the following:

  • the numbers in the chart are coming in currency e.g : 20,000,000 → $20,000,000 and -20,000,000 -->($20,000,000)

  • the height and the width of the chart

thx in advance

You need to format the values in the cell as 0.00 or @.

i want to show the negative and the positive number