Results 1 to 7 of 7
  1. #1
    ravi1 is offline Member
    Join Date
    Mar 2011
    Posts
    19
    Rep Power
    0

    Smile read data from incoming Excel chart and create graph

    Hello I am having trouble with the above. I want to get data from a source
    (which saves the data in an excel file), and using this data I want to plot a chart with it.

    I have looked for examples online but they dont deal with getting from an excel chart.

    I cant plot using the data using an excel graph because the data is large and incoming all the time and only specific columns and rows will be read.

    If there is someone out there, I will be grateful

    Thanks

    Rav

  2. #2
    ozzyman's Avatar
    ozzyman is offline Senior Member
    Join Date
    Mar 2011
    Location
    London, UK
    Posts
    797
    Blog Entries
    2
    Rep Power
    4

    Default

    the concept is wrong, you should be reading the raw data and creating your own graph from it in java. to expect java to read an excel chart object doesnt make sense and would be incredibly complicated although probably possible.

    why not read the figures that the excel chart is made of and draw your own graph?

  3. #3
    ravi1 is offline Member
    Join Date
    Mar 2011
    Posts
    19
    Rep Power
    0

    Default

    Thanks for the reply. I have the raw data, I just need to draw the graph in Java rather than in excel as I have a GUI that will be reading the data from a set of data and draw a graph.

    Hope this helps



    Thanks

  4. #4
    ravi1 is offline Member
    Join Date
    Mar 2011
    Posts
    19
    Rep Power
    0

    Default

    anyone?

    Cheers

  5. #5
    DarrylBurke's Avatar
    DarrylBurke is offline Forum Police
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,423
    Rep Power
    20

    Default

    Try JFreeChart

    db

  6. #6
    ravi1 is offline Member
    Join Date
    Mar 2011
    Posts
    19
    Rep Power
    0

    Default

    Cheers for that, I have a GUI and want to draw a chart on it, will JFreechart work with it and how?

    Regards

  7. #7
    ravi1 is offline Member
    Join Date
    Mar 2011
    Posts
    19
    Rep Power
    0

    Default

    Anyone? I want to plot a graph using my GUI. I cant use jfreechart as it shows me compilation errors if I run it.

    Any other way to run it in a GUI.

    Regards

Similar Threads

  1. Replies: 2
    Last Post: 05-12-2010, 12:03 PM
  2. How can I create Graph(Data structure) with Java ?
    By mir.shahidul in forum Advanced Java
    Replies: 2
    Last Post: 02-10-2009, 10:19 AM
  3. How can I create Graph(Data structure) with Java
    By mir.shahidul in forum New To Java
    Replies: 4
    Last Post: 02-09-2009, 08:48 AM
  4. How to read data from excel and store it in db
    By saran123 in forum New To Java
    Replies: 5
    Last Post: 10-03-2008, 10:19 AM
  5. Java chart & graph lib
    By saturdaybugs in forum Java 2D
    Replies: 1
    Last Post: 04-24-2008, 01:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •