Thanks "Monks" for the valuable suggestions.
I have re-designed my work now. I am populating all the data to one sheet of a workbook and need to carry it from now. As mentioned earlier i am using Win32::OLE package only (Windows) as against Spreadsheet::??? and would like to continue using the Win32::OLE package only.
My requirement now is drawing a Pie chart using data of columns 1(Module Name) and column 4(Result). Could any of you guys throw some light over this. The chart should show the module name and corresponding result value with distinct colors.
Thanks,
Hemanth
Hello Guys,
My requirement is drawing a Pie chart using data of columns 1(Module Name) and column 4(Result) of a workbook. How to go about doing this? The Pie Chart should show the value of each pie and the Module names should be indexed against respective colour.