Create charts

Create charts and bind worksheet data.

Validation status: This example is published for documentation purposes, but the current released package does not expose the API namespace used by the source example. It requires package/API alignment before it can be marked runnable against NuGet.

Requirements

  • .NET Framework 4.8 for the released package path.
  • DRIT.Spreadsheet NuGet package.
  • No Microsoft Excel installation is required.

Run the example

dotnet run --project .\DRIT.Spreadsheet.Examples.Console\Charts\Charts.csproj -f net48

Source

View this example on GitHub

Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using DRIT.Spreadsheet;
using DRIT.Spreadsheet.Chart;
using DRIT.Spreadsheet.Chart.Office;
using DRIT.Spreadsheet.Office.Chart;
using DRIT.Spreadsheet.Drawing;
using DRIT.Spreadsheet.Examples.Shared;

namespace Charts
{
    class Program
    {
        static void Main(string[] args)
        {
            var workbook = new Workbook();

            var worksheet = workbook.Worksheets[0];
            worksheet.Name = "Data";
            //var sheet = workbook.AddWorksheet("SourceData");

            worksheet.GetRange("A1:D1").SetColumnsWidthPixel(110);

            worksheet.GetRange("B1:D1").SetValue(new[] { "Series 1", "Series 2", "Series 3" });
            worksheet.GetRange("A2:A5").SetValue(new[] { "Point 1", "Point 2", "Point 3", "Point 4" });
            worksheet.GetRange("B2:B5").SetValue(new[] { 2, 4, 6, 8 });
            worksheet.GetRange("C2:C5").SetValue(new[] { 4, 3, 2, 1 });
            worksheet.GetRange("D2:D5").SetValue(new[] { 2, 1, -1, -2 });

            TwoDArea(workbook);
            ThreeDArea(workbook);
            TwoDBar(workbook);
            TwoDLine(workbook);
            ThreeDLine(workbook);

            workbook.SaveAs(ExampleSupport.OutputPath("ChartTypes.xlsx"));
        }

        public static void TwoDArea(Workbook workbook)
        {
            var worksheet = workbook.AddWorksheet("2-D Area");

            var cellOffset = new PointDoubleUnit(19050, 19050, ScreenMeasurementUnit.Emu);
            worksheet.GetRange("A1:A4").SetRowsHeight(66);

            worksheet.GetRange("A8:A11").SetRowsHeight(66);

            var chart1 = worksheet.Charts.Add<AreaChart>(2, "Chart 1", "A1", cellOffset);
            chart1.Size.HeightInches = 2.5;
            chart1.Size.WidthInches = 3.5;
            chart1.DataSource = "Data!$A$1:$D$5";

            var chart2 = worksheet.Charts.Add<AreaChart>(3, "Chart 2", "A7", cellOffset);
            chart2.Size.HeightInches = 2.5;
            chart2.Size.WidthInches = 3.5;
            chart2.Grouping = Grouping.Stacked;
            chart2.DataSource = "Data!$A$1:$D$5";
        }

        public static void ThreeDArea(Workbook workbook)
        {
            var worksheet = workbook.AddWorksheet("3-D Area");

            var cellOffset = new PointDoubleUnit(19050, 19050, ScreenMeasurementUnit.Emu);
            worksheet.GetRange("A1:A4").SetRowsHeight(66);

            worksheet.GetRange("A8:A11").SetRowsHeight(66);

            var chart1 = worksheet.Charts.Add<Area3DChart>(2, "Chart 1", "A1", cellOffset);
            chart1.Size.HeightInches = 2.5;
            chart1.Size.WidthInches = 3.5;
            chart1.DataSource = "Data!$A$1:$D$5";

            var chart2 = worksheet.Charts.Add<Area3DChart>(3, "Chart 2", "A7", cellOffset);
            chart2.Size.HeightInches = 2.5;
            chart2.Size.WidthInches = 3.5;
            chart2.Grouping = Grouping.Stacked;
            chart2.DataSource = "Data!$A$1:$D$5";
        }

        public static void TwoDBar(Workbook workbook)
        {
            var worksheet = workbook.AddWorksheet("2-D Bar");

            var cellOffset = new PointDoubleUnit(19050, 19050, ScreenMeasurementUnit.Emu);
            worksheet.GetRange("A1:A4").SetRowsHeight(66);

            worksheet.GetRange("A8:A11").SetRowsHeight(66);

            var chart1 = worksheet.Charts.Add<BarChart>(2, "Chart 1", "A1", cellOffset);
            chart1.Grouping = BarGrouping.Clustered;
            chart1.Size.HeightInches = 2.5;
            chart1.Size.WidthInches = 3.5;
            chart1.DataSource = "Data!$A$1:$D$5";

            var chart2 = worksheet.Charts.Add<BarChart>(3, "Chart 2", "A7", cellOffset);
            chart2.Grouping = BarGrouping.Stacked;
            chart2.Size.HeightInches = 2.5;
            chart2.Size.WidthInches = 3.5;
            chart2.DataSource = "Data!$A$1:$D$5";
        }

        

        public static void TwoDLine(Workbook workbook)
        {
            var worksheet = workbook.AddWorksheet("2-D Line");

            var cellOffset = new PointDoubleUnit(19050, 19050, ScreenMeasurementUnit.Emu);
            worksheet.GetRange("A1:A4").SetRowsHeight(66);

            worksheet.GetRange("A8:A11").SetRowsHeight(66);

            var chart1 = worksheet.Charts.Add<LineChart>(2, "Chart 1", "A1", cellOffset);
            chart1.Size.HeightInches = 2.5;
            chart1.Size.WidthInches = 3.5;
            chart1.DataSource = "Data!$A$1:$D$5";

            var chart2 = worksheet.Charts.Add<LineChart>(3, "Chart 2", "A7", cellOffset);
            chart2.Size.HeightInches = 2.5;
            chart2.Size.WidthInches = 3.5;
            chart2.Grouping = Grouping.Stacked;
            chart2.DataSource = "Data!$A$1:$D$5";
        }

        public static void ThreeDLine(Workbook workbook)
        {
            var worksheet = workbook.AddWorksheet("3-D Line");

            var cellOffset = new PointDoubleUnit(19050, 19050, ScreenMeasurementUnit.Emu);
            worksheet.GetRange("A1:A4").SetRowsHeight(66);

            worksheet.GetRange("A8:A11").SetRowsHeight(66);

            var chart1 = worksheet.Charts.Add<Line3DChart>(2, "Chart 1", "A1", cellOffset);
            chart1.Size.HeightInches = 2.5;
            chart1.Size.WidthInches = 3.5;
            chart1.DataSource = "Data!$A$1:$D$5";

        }
    }
}