Introduction

Developers can add a variety of charts to their spreadsheets using Aspose.Cells. Aspose.Cells provides many charting objects that can be used to create charts in a flexible manner. The primary aim of this topic is to make developers familiar with the charting objects of Aspose.Cells so that they may create any kind of chart easily.

Things to Know Before Creating a Chart

Before we start demonstrating the creation of charts, it's important to discuss some basic concepts that would be very helpful for the developers to create any kind of charts using Aspose.Cells.

Charting Objects

Aspose.Cells provides some special set of classes that are used to create all kinds of charts supported by Aspose.Cells. These classes are used to create Charting Objects, which act as the building blocks of a chart. These charting objects are listed below:

• ASeries, represents a single data series in a chart
• Axis, represents a chart's axis
• Chart, represents a single Excel chart
• ChartArea, represents the chart area in the worksheet
• ChartDataTable, represents a chart data table
• ChartFrame, represents the frame object in a chart
• ChartPoint, represents a single point in a series in a chart
• ChartPoints, represents a collection that contains all the points in one series
• Charts, represents a collection of Chart objects
• DataLabels, represents a collection of all the DataLabel objects for the specified ASeries
• FillFormat, represents fill format for a shape
• Floor, represents the floor of a 3D chart
• Legend, represents the chart legend
• Line, represents the chart line
• NSeries, represents a collection of ASeries objects
• TickLabels, represents the tick mark labels associated with tick marks on a chart axis
• Title, represents the title of a chart or axis
• Trendline, represents a trendline in a chart
• Trendlines, represents a collection of all Trendline objects for the specified data series
• Walls, represents the walls of a 3D chart

Using Charting Objects

As we have told above, all charting objects are the instances of their respective classes that provide specific properties and methods to perform specific tasks. Developers can use these charting objects to create charts according to their requirements.

Developers can add any type of chart to their worksheets using the Charts collection. Each item in the Charts collection represents a Chart object. A Chart object encapsulates all other Charting Objects that are required to customize the appearance of a chart. In our next section, we will learn the use of few basic charting objects to create a simple chart.

Creating a Simple Chart

Developers can create many types of charts using Aspose.Cells. All types of standard charts supported by Aspose.Cells are pre-defined in an enumeration named as ChartType. These pre-defined chart types in the ChartType enumeration are as follows: