Oracle APEX 4.0 Charts Inside Out - Expert Oracle Application Express - page 132

xmlelement("tooltip", xmlattributes('true' as "enabled"), xmlelement("format", 'Job: ' 
|| job)) ) )).getClobVal()
INTO l_xml
FROM emp;
In the point node you now added a tooltip node. The XML that gets generated looks like
this:
<series name="Series 2" y_axis="extra_y_axis_1">
<point name="SMITH" y="0">
<tooltip enabled="true">
<format>Job: CLERK</format>
</tooltip>
</point>
<point name="ALLEN" y="300">
<tooltip enabled="true">
<format>Job: SALESMAN</format>
</tooltip>
</point>
…
<point name="FORD" y="0">
<tooltip enabled="true">
<format>Job: ANALYST</format>
</tooltip>
</point>
<point name="MILLER" y="0">
<tooltip enabled="true">
<format>Job: CLERK</format>
</tooltip>
</point>
</series>
To let the user define the width and height of the chart, you need to add two other dynamic actions
that fire when the user changes the width and height text items. Here are the steps to do this:
Add a new Advanced Dynamic Action with the name: Change Chart Width

• Event: Change

• Selection Type: Item(s)

• Item(s): P7_CHART_WIDTH

• True Actions

• Action: Execute JavaScript Code

• Fire When Event Result is: True

• Fire On Page Load: No

• Code:
chart.width = $v('P7_CHART_WIDTH');
chart.write('chartDiv');
Add a new Dynamic Action with the name: Change Chart Height