chart and chart values at the same excel sheet

[Klaus Thrien]

Hi,

how can I create an excel worksheet with chart and chart values at the same sheet? The example I found always creates a second sheet for the chart.

[Melba Winshia]

Hi Klaus,

Thank you for your interest in Syncfusion products.

You can create an excel worksheet with chart and chart values at the same sheet by adding the chart in the sheet which has chart values.

[C#]

//Add Chart to sheet
IChartShape chart = sheet.Charts.Add();

Please refer to the sample that is shipped with Essential XlsIO which could be found in the below link.

C:\Documents and Settings\{user}\My Documents\Syncfusion\EssentialStudio\5.1.0.51\Windows\XlsIO.Windows\Samples\2.0\Charts\EmbeddedChart\cs

Please try this and let me know if this helps.

Thanks,
Melba