wood burning stoves*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Plotting a graph in Excel" Watch "Plotting a graph in Excel" New topic
Author

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
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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
Rancher

Joined: Sep 21, 2011
Posts: 2408
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
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Plotting a graph in Excel
 
Similar Threads
How to draw Fan Graphs in Excel File using a ResultSet
Quick question
Excel Charts and JSPs
creating graph using Applet
XY chart in Excel