read data from incoming Excel chart and create graph

[ravi1]

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

[ozzyman]

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?

[ravi1]

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

[ravi1]

anyone?

Cheers

[DarrylBurke]

Try JFreeChart

db

[ravi1]

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

Regards

[ravi1]

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