Adding graph in excel based on the content of ADFdi Table
- by Arun
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.
Pre-requisites:
Microsoft Office 2007
JDeveloper 11.1.1.1.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).
And, for the Category Axis, we select the Ename header row and the row below it (by holding Shift key).
We can get the chart now, by running the Workbook and downloading the data into the table.
This simple example can be enhanced for complex graphs by using the data from the ADFdi table to use the power of excel along with ADF Desktop Integration.
