We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Multiple Pie Chart in one sheet


How can I create multiple pie chart in one excel sheet(without chart web control) all in code behind. I found one sample which only creates a single piechart. I have attached the sample chart I want to create, It would be great if I can get code example

Thank you



1 Reply

VK Vijayabharathi K Syncfusion Team March 11, 2013 12:11 PM UTC

Hi Theo,


Thanks for using Syncfusion products.

We can draw the chart control as bitmap image and add it to the sheet of excel file for your requirements. Since, we don’t have built-in functionality to export the multiple chart to excel. Kindly refer the below code snippet to achieve this,



            string exportFileName = "Chart.xls";

            //A new workbook with a worksheet is created.

            IWorkbook chartBook = ExcelUtils.CreateWorkbook(1);

            IWorksheet sheet = chartBook.Worksheets[0];

            int toprow = 4, topcolumn = 5, bottomrow = 20, bottomcolumn = 12;


            for (int i = 0; i < 2; i++)


                Bitmap img = new Bitmap((int)chart[i].Width.Value, (int)chart[i].Height.Value);



                string chartimage = "chartimage" + i + ".Jpg";

                sheet.Pictures.AddPicture(toprow, topcolumn, bottomrow, bottomcolumn, img);

                topcolumn = bottomcolumn + 3;

                bottomcolumn = topcolumn + 7;




            //Save the Chart book.





Please refer the attached sample for this requirements and let us know if any concerns.





Live Chat Icon For mobile
Up arrow icon