How to Add a Chart to your Spreadsheet using Java (Video)

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!