Oracle Forms (MOSC)

MOSC Banner

OLE2 and Excel. how to add a pie chart into an Excel Sheet

edited Mar 28, 2012 8:47PM in Oracle Forms (MOSC) 10 commentsAnswered
hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center