using excel charts in navision Classic

Business Central/NAV User Forum
1

hi , i am using navision classic to create excel charts WITHOUT USING CHART WIZARD, i have 2 problem :

i cant create BAR CHART, i cant find the chart type number

i cant add the % to the Pie Chart

can any one find the solution of that?

2

Hi Emrad

try this link

http://it.toolbox.com/wiki/index.php/EXCEL_Chart_Type_Enumeration

3

thx Akhilesh for the link, i still have 1 problem, i have the following code:

IF g_Bar THEN BEGIN

g_ChartType := 62;

END ELSE IF g_Line THEN BEGIN

g_ChartType := 4;

END ELSE BEGIN

g_ChartType := -4102;

END;

xlChartObjects := xlSheet.ChartObjects;

xlChartObject := xlChartObjects.Add(10,80,300,250);

xlChart := xlChartObject.Chart;

xlRange := xlSheet.Range(‘A2’,‘L3’);

xlChart.SetSourceData(xlRange);

xlChart.ChartType := g_ChartType;

i’ve got the following error : “The call to the member Add failed. S return the following message :the specified dimension is not valid for the current chart type”.

any suggestion??