POI give you access to Excel in a Java environment. However, I can't remember if VBA stretches to creating charts. I suspect not, but someone may correct me.
You can't create an excel chart with Java using POI, but if you already have a chart template in an excel file then you can modify the data and those changes will be reflected in the chart. VBA does have a Chart object but I don't know how you access that with Java [ March 23, 2005: Message edited by: Nigel Browne ]
Thanks for the suggestion. I think i will go about doing that, the only problem I have is time. So if there exists any sample code to read from and update spreadheets using POI it will be very very very helpful.
Cheers guys
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.