Insert a Chart in Excel Spreadsheet using EPPlus Library.

EPPlus is .NET Library that makes it very easy to manipulate Excel programmatically. It is based on Open XML.

Below is the sample code we can use to insert a chart in a excel spreadsheet.

<p>public void UpdateExcelUsingEPPlus(string fileName)<br />
{<br />
FileInfo fileInfo = new FileInfo(fileName);</p>
<p>ExcelPackage p = new ExcelPackage(fileInfo);</p>
<p>// access the first sheet named Sheet1<br />
ExcelWorksheet myWorksheet = p.Workbook.Worksheets["Sheet1"];</p>
<p>// specify cell values to be used for generating chart.<br />
myWorksheet.Cells["C2"].Value = 10;<br />
myWorksheet.Cells["C3"].Value = 40;<br />
myWorksheet.Cells["C4"].Value = 30;</p>
<p>myWorksheet.Cells["B2"].Value = "Yes";<br />
myWorksheet.Cells["B3"].Value = "No";<br />
myWorksheet.Cells["B4"].Value = "NA";</p>
<p>// add chart of type Pie.<br />
var myChart = myWorksheet.Drawings.AddChart("chart", eChartType.Pie);</p>
<p>// Define series for the chart<br />
var series = myChart.Series.Add("C2: C4", "B2: B4");<br />
myChart.Border.Fill.Color = System.Drawing.Color.Green;<br />
myChart.Title.Text = "My Chart";<br />
myChart.SetSize(400, 400);</p>
<p>// Add to 6th row and to the 6th column<br />
myChart.SetPosition(6, 0, 6, 0);</p>

The output –

If we want to do it using Open XML SDK without using EPPlus Library we can refer to the below article.

Hope it helps..


Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

One thought on “Insert a Chart in Excel Spreadsheet using EPPlus Library.”

  1. You can use ZetExcel for empowering you to build cross-platform applications having the ability to generate, modify, convert, render and print spreadsheets without using Microsoft Excel. Feel free to try it


Please share your thoughts

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.