Excel Charts in navision

Business Central/NAV User Forum
1

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

2

You are generating in classic or RTC?

If classic You can check my blog.

3

hi,

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