[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
  Prerequisites
 [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]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Tables
   [Collapse]Charts and Graphics
     Charting Overview
     Create and Modify a Chart Programmatically
     Shapes
     Pictures
    Printing
    Events
   [Expand]Mail Merge
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Keyboard Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [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]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[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 allows you to create charts, which help you analyze large amounts of data and show the relationship between different data sets.

The SpreadsheetControl uses DevExpress WinForms Charts to render charts. The chart types and layouts are compatible with those of Microsoft® Excel®.

Refer to the Charts section for examples of how to create a chart in code using the SpreadsheetControl's Chart API. You can insert a chart into a worksheet with data or create a standalone chart on a chart sheet.

Note

You can also embed small charts, or sparklines, in worksheet cells. Refer to the Sparklines section for examples on how to create sparkline groups of different types and adjust their appearances.

End users can select a chart on the Insert tab in the Charts group.

Expanded Supported Chart Types

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
  • 3-D Stacked Column
  • 3-D 100% Stacked Column
  • 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

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

Pie Charts

2-D Pie Charts:

  • Pie
  • Exploded Pie

3-D Pie Charts:

  • 3-D Pie
  • 3-D Exploded Pie

Doughnut Charts

  • Doughnut
  • Exploded Doughnut

Bar Charts

2-D Bar Charts:

  • Clustered Bar
  • Stacked Bar
  • 100% Stacked Bar

3-D Bar Charts:

  • 3-D Clustered Bar
  • 3-D Stacked Bar
  • 3-D 100% Stacked Bar

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

Area Charts

2-D Area Charts:

  • Area
  • Stacked Area
  • 100% Stacked Area

3-D Area Charts:

  • 3-D Area
  • 3-D Stacked Area
  • 3-D 100% Stacked Area

Scatter Charts

  • Scatter
  • Scatter with Smooth Lines and Markers
  • Scatter with Smooth Lines
  • Scatter with Straight Lines and Markers
  • Scatter with Straight Lines

Bubble Charts

  • Bubble
  • 3-D Bubble

Stock Charts

  • High-Low-Close
  • Open-High-Low-Close
  • Volume-High-Low-Close
  • Volume-Open-High-Low-Close

Radar Charts

  • Radar
  • Radar with Markers
  • Filled Radar

Expanded Chart Elements

The image below shows a chart's basic elements.

  • Chart Area - represents the entire chart and all its elements.
  • Plot Area - the chart's area that displays data series, axes, gridlines and data labels.
  • Data Point - a single value plotted on a chart.
  • Data Series - a group of related data points. Each data series has a unique color to distinguish between individual series on a chart with multiple series.
  • Horizontal and Vertical Axes - two perpendicular lines that run along the chart edges. Axes display category labels and measurement units. Most charts have two axes: the category axis (X-axis), usually running horizontally along the bottom of the plot area, and the value axis (Y-axis), usually running vertically on the plot area's left side. 3-D charts also have the depth (series) axis that displays series names. The bubble and scatter charts have two value axis. The pie and doughnut charts have no axes at all.
  • Legend - identifies each data series with a color or fill pattern. A chart can have only one legend.
  • Chart Title - a text header that explains a chart's purpose.
  • Axis Title - explanatory text used to label an axis.
  • Data Label - identifies a data point with its actual value.
  • Gridlines - a series of horizontal and vertical lines running across the plot area. You can add gridlines to a chart to improve its readability.

You can add or remove chart elements to customize a chart's layout, as described in the Create and Modify a Chart Programmatically topic and the Charts example section.

End users can use commands on the Chart Tools contextual tab to apply one of the predefined chart layouts or manually select elements to display on a chart.

  • Select a predefined chart layout

  • Show or hide chart elements

Expanded See Also

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