Excel Chart Types through JAVA

On our way to explore things, we have acquainted with how we can make our customized excel sheet with simple java code. We have also dealt with the chart types that can make our excel sheet presentable.

In my earlier article, we have seen how we have engraved the data with a particular format with chart showing the data. The chart we have created is of line type.

However, there are ways to change the chart types. In the code that I have mentioned in the previous article, the chart type is set using the following line of chart.setChartType(GRChart.eChartLine);

The chart type we are using here is of Line type which shows the data in a line graphics. There are plenty of chart types which can be found in the java docs of the Jxcell. The chart type includes: GRChart.ChartArea,
eChartBar,
eChartBubble,
eChartColumn,
eChartCombination,
eChartDoughnut,
eChartLine,
eChartPie,
eChartScatter,
eChartStep.

The above chart types can be used extensively after providing suitable data.

There are plenty of other things that you can explore about the Jxcell API which is useful for editing/creating the excel application.

You can download the Jxcell API Docs from http://www.jxcell.net/jxcell.zip.

Hope you all will find it useful.