how to make a pie chart in excel with non adjacent ranges

The example below uses the SeriesCollection charting object to specify the chart’s data source.

Use any of the charting objects encapsulated in the Chart object to manage the chart.Access the new Chart object from the Charts collection by passing its index.Specify the type of chart with the ChartType enumeration.įor example, the example below uses the ChartType.Pyramid value as the chart type.Add a chart to the worksheet by calling the Charts collection’s Add method, encapsulated in the Worksheet object.

This will be used as the data source for the chart.

Add some data to worksheet cells with the Cell object’s PutValue method.

The next section shows how to use a few basic charting objects to create a simple chart. A Chart object encapsulates all other charting objects required to customize the appearance of the chart. Each item in the Charts collection represents a Chart object. Use charting objects to create charts.Īdd any type of chart to a worksheet using the Charts collection.

TrendlineCollection, a collection of all Trendline objects for the specified data series.Īs mentioned above, all charting objects are instances of their respective classes and provide specific properties and methods to perform specific tasks.

TickLabels, the tick mark labels associated with tick marks on a chart axis.

SeriesCollection, a collection of Series objects.

DataLabels, a collection of all the DataLabel objects for the specified series.

ChartPointCollection, a collection that contains all the points in one series.

ChartPoint, a single point in a series in a chart.

ChartFrame, the frame object in a chart.

ChartArea, the chart area in the worksheet.

Series, a single data series in a chart.

These classes are used to create charting objects, which act as the chart building blocks. Charting ObjectsĪspose.Cells provides a special set of classes in the namespace used to create the charts supported by Aspose.Cells. It’s simple to create a chart with Aspose.Cells with the following example codes:īefore creating charts it’s important to understand some basic concepts that are helpful when creating charts using Aspose.Cells. This topic discusses Aspose.Cells' charting objects.

Aspose.Cells provides many flexible charting objects. It is possible to add a variety of charts to spreadsheets with Aspose.Cells.

How to make a pie chart in excel with non adjacent ranges