Create chart in Excel spreadsheet using C#

Microsoft Office Excel is a spreadsheet application that allows you to edit spreadsheet data and visualize spreadsheet data using charts. Excel supports the following chart types: Column, Line, Pie, Bar, Area, X Y (Scatter), Map, Stock, Surface, Radar, Treemap, Sunburst, Histogram, Box & Whisker, Waterfall, Funnel, Combo.

VintaSoft Imaging .NET SDK + VintaSoft Office .NET Plug-in provides powerful .NET API for work with spreadsheets stored in XLSX file.
VintaSoft Imaging .NET SDK allows to create Excel charts of the following types:

• Column (Clustered Column; Stacked Column; 100% Stacked Column; 3D Clustered Column; 3D Stacked Column; 3D 100% Stacked Column; 3D Column)
• Line (Line; Stacked Line; 100% Stacked Line; Line with Markers; Stacked Line with Markers; 100% Stacked Line with Markers; 3D Line)
• Pie (Pie; Doughnut)
• Bar (Clustered Bar; Stacked Bar; 100% Stacked Bar; 3D Clustered Bar; 3D Stacked Bar; 3D 100% Stacked Bar)
• Area (Area; Stacked Area; 100% Stacked Area; 3D Area; 3D Stacked Area; 3D 100% Stacked Area)
• X Y (Scatter) (Scatter; Scatter with Smooth Lines and Markers; Scatter with Smooth Lines; Scatter with Straight Lines and Markers; Scatter with Straight Lines; Bubble; 3D Bubble)
• Stock (High-Low-Close; Open-High-Low-Close; Volume-High-Low-Close; Volume-Open-High-Low-Close)

To create a chart in an Excel spreadsheet using VintaSoft Imaging .NET SDK you should complete the following steps:

• Open or create a spreadsheet to which you want to add the chart.
• Add data for the chart to the spreadsheet.
• Create XLSX chart.
• Specify data for the XLSX chart.
• Add XLSX chart to Excel spreadsheet.

Here is C# code demonstrating how to add a "standard" chart to Excel spreadsheet:

public static void AddStandardChartToXlsxWorksheet(string outXlsxFilename)
{
    // create a spreadsheet editor for synchronous editing of new spreadsheet document
    using (SpreadsheetEditor editor = SpreadsheetEditor.CreateEditor())
    {
        // get the first worksheet (empty)
        Worksheet sheet = editor.Document.Worksheets[0];
        
        // start the worksheet editing
        WorksheetEditor worksheetEditor = editor.StartEditing(sheet);

        // set worksheet name
        worksheetEditor.SetName("Example of add chart");
        
        // set categories and series for chart
        editor.SetCellValue(sheet, "A2", "Series 1");
        editor.SetCellValue(sheet, "A3", "Series 2");
        editor.SetCellValue(sheet, "A4", "Series 3");
        editor.SetCellValue(sheet, "B1", "Category 1");
        editor.SetCellValue(sheet, "C1", "Category 2");
        editor.SetCellValue(sheet, "D1", "Category 3");
        editor.SetCellValue(sheet, "E1", "Category 4");

        // set sample values for chart
        editor.SetCellValue(sheet, "B2", 5);
        editor.SetCellValue(sheet, "C2", 15);
        editor.SetCellValue(sheet, "D2", 45.5);
        editor.SetCellValue(sheet, "E2", 35);
        editor.SetCellValue(sheet, "B3", 110);
        editor.SetCellValue(sheet, "C3", 90);
        editor.SetCellValue(sheet, "D3", 88);
        editor.SetCellValue(sheet, "E3", 25);
        editor.SetCellValue(sheet, "B4", 15);
        editor.SetCellValue(sheet, "C4", 50);
        editor.SetCellValue(sheet, "D4", 20);
        editor.SetCellValue(sheet, "E4", 45);

        // add new Line chart to the worksheet
        SheetDrawing chart = editor.AddChart(sheet, StandardChartType.Line_LineWithMarkers_Horizontal, "A1:E4", new SheetDrawingLocation("A7:F17"));
        // set the chart title
        worksheetEditor.CreateChartPropertiesEditor(chart).SetTitle("Line Chart Example (Horizontal)");

        // finish the spreadsheet editing
        editor.FinishEditing();

        // save created spreadsheet document to a XLSX file
        editor.SaveAs(outXlsxFilename);
    }
}