Data Formatting in Charts

Setting Chart Data

There are two types of data to deal with while working on charts using Aspose.Cells as follows:

Chart Data

Chart data is that data that we use as a data source to build our charts. We can add a range of the cells (containing chart data) by calling the SeriesCollection object’s Add method.

Category Data

Category data is used for the labeling of chart data and can be added to SeriesCollection by using its setCategoryData method.

Column chart with chart & category data


Advance topics