[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Collapse]Charting Overview
     Chart Elements
     Create and Modify a Chart Programmatically
   [Expand]Mail Merge Overview
    Find and Replace
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Charting Overview

The SpreadsheetControl provides the capability to summarize worksheet data visually using a variety of charts. Charts display data series visually to make data interpretation easier, and show the relationship between different data series.


The SpreadsheetControl also allows you to add sparklines to your document. Refer to the Sparklines section for examples on how to create sparkline groups of different types, and adjust their formatting and scaling options.

To create a chart, click the chart type you wish to insert in the Charts group within the Insert tab. The SpreadsheetControl's native chart engine displays charts so that they closely match their appearance in Microsoft® Excel®.

For an example on how to create a chart in code by using the SpreadsheetControl Chart API, refer to the Charts section. You can insert a chart into a worksheet, or create a standalone chart by placing it on a separate sheet - a chart sheet.

Below is a list of all charts currently available in the SpreadsheetControl.

Chart Type

Chart Subtypes


Column Charts

2-D Column Charts:
  • Clustered Column
  • Stacked Column
  • 100% Stacked Column
3-D Column Charts:
  • 3-D Clustered Column
  • Stacked Column in 3-D
  • 100% Stacked Column in 3-D
  • 3-D Column
Cylinder Charts:
  • Clustered Cylinder
  • Stacked Cylinder
  • 100% Stacked Cylinder
  • 3-D Cylinder
Cone Charts:
  • Clustered Cone
  • Stacked Cone
  • 100% Stacked Cone
  • 3-D Cone
Pyramid Charts:
  • Clustered Pyramid
  • Stacked Pyramid
  • 100% Stacked Pyramid
  • 3-D Pyramid

Column charts are used to display series as sets of vertical bars (or columns) that are grouped by category. The bar lengths are proportional to the values that they represent. Column charts are typically used to compare values in different categories. Some column graphs display series as individual columns, grouped by category, and others show columns divided into subparts to show a cumulative effect (stacked column graphs). You can select column charts of different shapes, such as cylinder, cone or pyramid.

Line Charts

2-D Line Charts:
  • Line
  • Stacked Line
  • 100% Stacked Line
  • Line with Markers
  • Stacked Line with Markers
  • 100% Stacked Line with Markers
3-D Line Charts:
  • 3-D Line

Line charts display information as a series of data points connected by line segments. This chart type is useful when you need to show trends for several series on the same diagram, and to compare values of several series for the same point argument.

Pie Charts

2-D Pie Charts:
  • Pie
  • Exploded Pie
3-D Pie Charts:
  • Pie in 3-D
  • Exploded Pie in 3-D
Doughnut Charts:
  • Doughnut
  • Exploded Doughnut

Pie and doughnut charts are used to compare the percentage values of different point arguments in the same series. These charts may be useful to determine which point value is the most significant, or which values in the point series are the most significant. A doughnut chart is functionally identical to a pie chart. The main difference is the shape of the doughnut chart, and that it can contain more than one data series.

Bar Charts

2-D Bar Charts:
  • Clustered Bar
  • Stacked Bar
  • 100% Stacked Bar
3-D Bar Charts:
  • Clustered Bar in 3-D
  • Stacked Bar in 3-D
  • 100% Stacked Bar in 3-D
Cylinder Charts:
  • Clustered Horizontal Cylinder
  • Stacked Horizontal Cylinder
  • 100% Stacked Horizontal Cylinder
Cone Charts:
  • Clustered Horizontal Cone
  • Stacked Horizontal Cone
  • 100% Stacked Horizontal Cone
Pyramid Charts:
  • Clustered Horizontal Pyramid
  • Stacked Horizontal Pyramid
  • 100% Stacked Horizontal Pyramid

Bar charts are identical to column charts with one exception: bar charts use horizontal bars instead of vertical bars to compare values across categories. Some bar graphs display series as individual bars grouped by category, and others show bars divided into subparts to show a cumulative effect (stacked bar graphs). You can select bar charts of different shapes, such as cylinder, cone or pyramid.

Area Charts

2-D Area Charts:
  • Area
  • Stacked Area
  • 100% Stacked Area
3-D Area Charts:
  • 3-D Area
  • Stacked Area in 3-D
  • 100% Stacked Area in 3-D

Area charts display series as filled areas in a diagram, with each data point displayed as a peak or valley in the area. This chart type is useful when you need to show trends for several series on the same diagram, and also show the relationship of the parts to the whole. The area chart is based on the line chart, with the area below the plotted line filled with color.

Scatter Charts

Scatter Charts:
  • Scatter with only Markers
  • Scatter with Smooth Lines and Markers
  • Scatter with Smooth Lines
  • Scatter with Straight Lines and Markers
  • Scatter with Straight Lines
Bubble Charts:
  • Bubble
  • Bubble with a 3-D Effect

Scatter charts are used to plot data points on the horizontal and vertical axis to show the relationship between two sets of data. This chart type combines data values into single data points and displays them in uneven intervals (or clusters).

Bubble charts allow you to visually represent data that has a third dimension, expressed in the bubble's size. You map two dimensions along the horizontal and vertical axes, and then the third dimension is displayed as a filled circle at the data point.

Stock Charts

Stock Charts:
  • High-Low-Close
  • Open-High-Low-Close
  • Volume-High-Low-Close
  • Volume-Open-High-Low-Close

Stock charts are used to show variation in stock prices over the course of a day. In the High-Low-Close chart type, the High and Low prices are represented by the top and bottom values of the vertical line that is shown at each point, and the Close prices are represented by the tick marks. In the Open-High-Low-Close chart type, the High and Low prices are shown in the same way as in the High-Low-Close charts, but the Open and Close prices are represented by the bottom and top borders of a rectangle. If the stock closes higher than its opening price, the rectangle is hollow. And if the stock closes lower than its opening price, the rectangle is filled. A stock chart can also contain volume information - the number of shares traded during a given time period.

Radar Charts

Radar Charts:
  • Radar
  • Radar with Markers
  • Filled Radar

Radar charts display data series on a circular grid with multiple axes, so values are shown relative to a center point.

Expanded See Also

Is this topic helpful?​​​​​​​