Data Formatting in Charts

In our previous topics, we have already provided many examples to demonstrate that how can you set a data source for your chart but in this topic, we are going to provide more details about the types of data that can be set for a chart.

Setting Chart Data

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

• Chart data.
• Category data.

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

• Create Dynamic Charts
• Easy way for Chart Setup using Chart.setChartDataRange method
• Find Type of X and Y Values of Points in Chart Series
• Set the Values Format Code of Chart Series