Graph Generation on Excel through AX

Finance and Operations/AX Developer Forum
1

Hi I have recently generated an excel sheet through AX code.

Now, I have to generate a graph on the same sheet through AX code.

2

If you use Excel Interop, get collection of chart objects for the worksheet and add a new chart - C# code would look somehow like this:

Worksheets("sheet1").ChartObjects.Add(100, 30, 400, 250)

You can find details about Chart’s members in documentation. This example could help you too.

3

Thanks Martin for the reply.I will get back to you after trying the same. :slight_smile: