Excel Charts in navision

hi ,

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

i want to generate the Bar chart and i cant find the code

Chartpage.ChartType := 4; for the line bar

Chartpage.ChartType := 5; for the pie bar

for the pie how can i show the % and the labels

can anyone assist me

You are generating in classic or RTC?

If classic You can check my blog.


the number format are shown in currency,

how can change the format number in the chart by navision coding??

i am using xlChart.ChartWizard(xlRange,2,7,1,1,0,0,‘title’);

how can i change the size of t he chart width and height