Create Excel Charts in Java

I've been using Apache POI to create and modify Excel s开发者_StackOverflow中文版preadsheets, but I'm wondering if there is a way (even if it's with a different library, preferably open source) to create charts in Excel in the new xlsx format. It looks like POI has an HSSFChart but I believe that's for the older format (please correct me if I'm wrong). Has anyone used a Java solution to create charts in Excel?

---

An option may be to create the charts beforehand and use POI to write the values where the chart can read them.

That is what I ended up doing, and it works great.

Make sure if you have formulas in your data, you go through every cell in the spreadsheet and evaluate them before writing it out to disk.

---

I have not used the Java edition of Aspose Cells but I've used the .NET edition and it is really nice. Over there it says that it can open and save XLSX. It's not free nor open source, though.

---

I prefer using JExcel to POI (the API is simpler) but it seems like they don't support the 2007 formats yet either.