Adding graph in excel based on the content of ADFdi Table

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.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Tips and Tricks from Oracle's JDeveloper & ADF QA

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today