Posts

Showing posts with the label chart

Multiple Line Chart in BI Publisher

Image
Here is a sample of how do you do Line-stacked graph. In BI Publisher menu, select chart and drag and drop the required column , do choose type of the chart as Line- Stacked. xml is available in the forum post and here it is

Chart Data Values

Image
In Chart generated from BI Publisher, how do i show the data points in the chart. Example, say on top of BAR being displayed,i want to display the data values. Have answered this many times, but did not note it down for others to refer. <MarkerText visible="true"> <Y1ViewFormat> <ViewFormat numberType="NUMTYPE_GENERAL" numberTypeUsed="true"  /> </Y1ViewFormat> </MarkerText> open the chart image in RTF, right click, format picture, got to ATL TEXT tab. add the following text between the element. http://forums.oracle.com/forums/thread.jspa?messageID=3595421&#3595421 http://forums.oracle.com/forums/thread.jspa?messageID=4093816&#4093816

Chart Title

Image
How to change the font and color in graph title Here it is. Use the Bi Publisher chart - option to change the fonts/color

PIE chart - Explode slice

In the pie chart, how to seperate the slices. if there is a support to for a way to separate the slices in pie chart was the question in the forum. Answer to this is a big YES :) In order to "explode" pie slices, add the following lines in the "Graph Settings" under the graph element. <SeriesItems> <Series id="0" pieSliceExplode="100"/> <Series id="1" pieSliceExplode="100"/> <Series id="2" pieSliceExplode="100"/> <Series id="3" pieSliceExplode="100"/> </SeriesItems> <Graph ...... pieDepth="25" pieTilt="25" ....> add this to your graph element attribute , to tilt the pie slices

Custom Scalefactor

By default the Y or X -axis scale in my graph reads as 0K, 20K, 40K... How to modify the scale to read 10000, 20000... or in some other custom formats? <Y1Axis> <ViewFormat scaleFactorUsed="true" scaleFactor="SCALEFACTOR_NONE" /> </Y1Axis> Attribute scale factor can take one of the following values. SCALEFACTOR_THOUSANDS | SCALEFACTOR_MILLIONS | SCALEFACTOR_BILLIONS | SCALEFACTOR_TRILLIONS | SCALEFACTOR_QUADRILLIONS

Chart : Different color based on cell value

Image
http://forums.oracle.com/forums/thread.jspa?messageID=3343920 http://forums.oracle.com/forums/thread.jspa?threadID=871513 This is little tricky, but do able.

Slice Label in Pie chart

Image
How to get the percentage, value or text in the pie chart slice label. use the following SliceLabel textType="LD_TEXT_PERCENT" textType takes the following value, (LD_VALUE | LD_PERCENT | LD_TEXT | LD_TEXT_PERCENT) Unfortunaltely, we cannot get he value and percentage both , as its not being supported by Oracle BIBEAN libraries