X
  • ADF
    March 11, 2011

Adding graph in excel based on the content of ADFdi Table

Arunkumar Ramamoorthy
Consulting Technical Manager

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.



EmpTable.JPG



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



Table&Graph-DT.JPG



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).




ChartDataSeries.JPG

And, for the Category Axis, we select the Ename header row and the row below it (by holding Shift key).




ChartLabelSeries.JPG


We can get the chart now, by running the Workbook and downloading the data into the table.




Table&Graph-RT.JPG



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.



Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.