Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Plotting a graph in Excel

 
budsy remo
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21316
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 103
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2894
46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic