I have a requirment,I have to draw a growth chart of a baby.The initial values will come from the excel file,i mean (Standerd growth data).The actual data will fetch from the database.So i have to show both the data's (the standerd and the actual data) in the chart.
Is there any useful api for creating a chart like this. i need the fractional vaues from the chart also
I have to plot the x and y values in the graph.
Can you please help me.
God Gave Me Nothing I Wanted<br />He Gave Me Everything I Needed<br /> - Swami Vivekananda
Have you looked around for any free charting APIs? Seems like I remember at least a couple. Google is your friend. One I specificly remember looking at was JFree.
After you pick one of those, your only issue is getting at the data. The DB access should be no problem since you have access to that. The Excel file read is the only potential issue and then its only an issue if you are trying to run the program on a nonWindows machine. If you are working exclusively on windows boxes, check out JDBC access to excel files. If you are running on a different OS, one solution might to actually keep an extra record in the DB that is the "Standard Baby" instead of an actual patient. Then Its just 2 DB calls instead of one for the chart. If that's not feasible for some reason, you could always export the excel data to a delimited text file and read it in that way.