GrapeCity Documents for Excel, Java Edition (GcExcel Java) is a high-speed, feature-rich Excel document API based on VSTO. We released the GcExcel for .NET Version in April, and with this launch it's now possible to use a similar package in Java applications.

This video is a step-by-step tutorial on how to add a chart to a spreadsheet using GcExcel, Java.

Step 1:

Initialize the workbook.

Step 2:

Add a worksheet and range of data to it.

Step 3.

Add a chart with chart type Column Clustered. The code above adds a chart type shape (where you specify the chart type and the location column).

Step 4:

Set the data as a series in the chart.

Step 5:

Set properties on the range of data.

Step 6:

Set number format on the chart axes.

Step 7:

Save the workbook.

If you have any questions or comments, please leave them in the comment thread below!

Happy coding!

Custom Code Your Spreadsheets in Java

Download the latest version of GrapeCity Documents for Excel, Java Edition

Download Now!