Generating graphs using excel automation

[ravicoder]

Hi all

I have Requirement for displaying graphs in an excel worksheet based on the data that is written into the sheet using excel automation

Could anyone point me in the right direction to do this ..?

My excel report shoul contain formatted data as well as the related graphs on another sheet in the same workbook

Any help / guidance / sample codes would be appreciated

thanks in advance
Ravi

 

[TamarGranor]

Assuming you're talking about using automation from VFP to create a chart in Excel, check out Excel's AddChart method:

https://learn.microsoft.com/en-us/office/vba/api/project.shapes.addchart

Tamar