Graph in Excel

Dev

hi all,

As we make report to excel is there any way that we can show data in the Graphical mode in excel through Navision


Any Help!!!

Sog

Developping a solution in NAV can be tedious.
You'll have to use automation a lot.
External businesses have excel self and linked it with Nav.
I suggest using an external application like JetReports.

JAKA

If You are using automation, You can also use the Excel ChartWizard on the data You have reported in Excel.

Report - OnPostReport()
{
VAR:
Book  Automation  'Microsoft Excel 11.0 Object Library'.Workbook
Range Automation  'Microsoft Excel 11.0 Object Library'.Range
Sheet Automation  'Microsoft Excel 11.0 Object Library'.Worksheet
Chart Automation  'Microsoft Excel 11.0 Object Library'.Chart
}
Range:=Sheet.Range('A3:B' + FORMAT(NoOfRecordsToPrint + 2));
Chart:=Book.Charts.Add;
Chart.ChartWizard(Range,-4100,2,2,1,0,0,Title,VTitle,HTitle);

Is this what You mean?