This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization 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
Pie
Posts: 20771
30
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: 2687
36
  • 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