File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other JSE/JEE APIs and the fly likes XY chart in Excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "XY chart in Excel" Watch "XY chart in Excel" New topic

XY chart in Excel

Vinod Tiwari
Ranch Hand

Joined: Feb 06, 2008
Posts: 466


I need to create an application while reads some set of data from the database and plots the XY graph with data in an excel and sends the report to a mailing list.

Could someone please guide me how can we plot the XY graph in excel using java?

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
The most capable API for creating Excel files in Java is Apache POI, and I'm fairly certain that it can't create embedded charts.

Your best bet may be to use OpenOffice in server mode, and use its Java API to drive the creation of such a file. That has a fairly steep learning curve, though.
I agree. Here's the link:
subject: XY chart in Excel
It's not a secret anymore!