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

Plotting a graph in Excel

budsy remo
Ranch Hand

Joined: Sep 20, 2008
Posts: 103
I have to take some values close to 1000 and then plot a graph in excel , so i was wondering if somebody could tell me what exactly to study ?
Thanks in advance .
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

My guess, based on the information you provided, is that you should study Excel. Do you have any other requirements beyond having to use Excel?
budsy remo
Ranch Hand

Joined: Sep 20, 2008
Posts: 103
Actually paul the thing is my program generates somewhere around 1000 values in an arraylist so just want to know that how do i connect my program with excel . Manually entering values and generating graph would be difficult .
Tim Moores

Joined: Sep 21, 2011
Posts: 2413
You can use a library such as Apache POI to create Excel files from your data. Or you can write them into an existing empty Excel file that has the graph defined already.
Peter Johnson

Joined: May 14, 2008
Posts: 5852

You could just write the values to a CSV file and then exec Excel to oepn the file and generate the graph.

But if I was doing this, I would generate the CSV file and then run R to generate the graph.

JBoss In Action
I agree. Here's the link:
subject: Plotting a graph in Excel
jQuery in Action, 3rd edition