Adding graph in excel based on the content of ADFdi Table
By Arunkumar Ramamoorthy-Oracle on Mar 11, 2011
Often we tend to represent the data present in the table in a graphical format to give a visual impression of the data. This article would be explaining the way to achieve it using the data we have in ADFdi table of the integrated workbook.
Microsoft Office 2007
JDeveloper 126.96.36.199.0 and above
Assuming we are already having an ADFdi enabled workbook with a table based on an Employee table as shown in the image below.
Also, add the table.download to the ribbon toolbar as menu item / as action for the startup event.
From excel, we'll add a new 3D bar chart
Now, we need to select the data range for the chart. We will take an example of chart based on the salary of the employees. So, the data for the X-Axis of the chart would be the Ename and the data for the Y-Axis being the salary. We can do that by right clicking on the Chart and selecting Select Data. We would select the Legend Entry Series name as the Sal header column in the table, and for the data, we select both the header row and the row below it (by holding Shift key).