OLE2 and Excel. how to add a pie chart into an Excel Sheet
I have created a Excel sheet by using OLE2 tool. Now I wish to add a pie chart which displays data from a range of cells. But I am experiencing some issues
1. Im not able to create the pie chart. I tried to set chartType to xl3DPieExploded, but it only shows an histogram
2. How can I set chart Data Source to the desired range? If I create a workchart within a worksheet, it select all cells from the beginning, until it founds an empty row, no matter if I try to set a data range.
3. if I write the following lines