Create charts in excel sheet in same sheet along with data C

Question

Can we make charts in Excel sheets using data directly from data tables and connect them to bar and pie charts? The same sheet can also contain a variety of other values given by c# code to other columns.

Please see attached image for a clear view.

Answer 1

Unfortunately, it's not that simple. Use the OpenXMLSDK, please. The ideal approach entails building an excel template file with charts in it, writing data to the excel sheets, and setting the data range of the charts to the data section.

OpenSDK-Download: http://www.microsoft.com/en-us/download/details.aspx?id=5124