ReoGrid supports various chart types that can be displayed on worksheets as floating objects. Charts update automatically when their data source changes, and they are saved/loaded with Excel files.

Namespace

using unvell.ReoGrid.Chart;
using unvell.ReoGrid.Drawing;

Available Chart Types

Class	Sample	Description
ColumnChart		Vertical bar chart
BarChart		Horizontal bar chart
LineChart		Line chart
AreaChart		Filled area chart
Pie2DChart		2D pie chart
DoughnutChart		Doughnut chart

Creating a Chart

Step 1: Prepare Data

var sheet = grid.CurrentWorksheet;

sheet["A2"] = new object[,] {
    { null, 2008, 2009, 2010, 2011, 2012 },
    { "City 1", 3, 2, 4, 2, 6 },
    { "City 2", 7, 5, 3, 6, 4 },
    { "City 3", 13, 10, 9, 10, 9 },
};

Step 2: Define Ranges

var dataRange = sheet.Ranges["B3:F5"];           // The numeric data
var serialNamesRange = sheet.Ranges["A3:A5"];    // Series names (row headers)
var categoryNamesRange = sheet.Ranges["B2:F2"];  // Category names (column headers)

Step 3: Create the Chart

var chart = new ColumnChart
{
    Location = new Graphics.Point(220, 160),
    Size = new Graphics.Size(400, 260),
    Title = "Column Chart Sample",
    DataSource = new WorksheetChartDataSource(sheet, serialNamesRange, dataRange)
    {
        CategoryNameRange = categoryNamesRange,
    },
};

Step 4: Add to Worksheet

sheet.FloatingObjects.Add(chart);

Chart Properties

All chart types inherit from the Chart base class:

Events

Data Source

WorksheetChartDataSource

Connects worksheet data to a chart:

// Constructor with ranges
var dataSource = new WorksheetChartDataSource(sheet, serialNamesRange, dataRange)
{
    CategoryNameRange = categoryNamesRange,
};

// Constructor with string addresses
var dataSource = new WorksheetChartDataSource(sheet, "A3:A5", "B3:F5")
{
    CategoryNameRange = sheet.Ranges["B2:F2"],
};

Constructors

Properties

Methods

Events

WorksheetChartDataSerial

Represents one data series in the chart:

Data Series Styles

Customize the appearance of each data series:

// Access styles by index
var style = chart.DataSerialStyles[0];

Example: Semi-Transparent Area Chart

foreach (var style in chart.DataSerialStyles)
{
    style.FillColor = new Graphics.SolidColor(100, style.FillColor.ToSolidColor());
}

Legend

Control the chart legend:

// Hide the legend
chart.ShowLegend = false;

// Access legend properties
var legend = chart.PrimaryLegend;

LegendPosition Enum

Axis Configuration (Axis Charts Only)

Column, Bar, Line, and Area charts inherit from AxisChart and support axis configuration:

AxisDataInfo Properties

Highlight Ranges

Highlight the data ranges on the worksheet to visually indicate the chart’s data source:

sheet.AddHighlightRange(dataRange);
sheet.AddHighlightRange(serialNamesRange);
sheet.AddHighlightRange(categoryNamesRange);

Chart Type Details

Class Hierarchy

FloatingObject
  └─ DrawingObject
      └─ DrawingComponent
          └─ Chart (base)
              ├─ AxisChart
              │   ├─ ColumnChart
              │   │   └─ BarChart
              │   ├─ LineChart
              │   └─ AreaChart
              └─ PieChart
                  ├─ Pie2DChart
                  └─ DoughnutChart

Related Topics

• Floating Objects — Managing floating objects on worksheets
• Drawing Shapes — Drawing shapes API