Tips for displaying the bar chart :

Ø      To get the Legend Area below the graph rather than beside the graph :

<LegendArea automaticPlacement=”AP_NEVER” position=”LAP_BOTTOM”/>

 

Ø      To make the size of legend text/tick labels proportional to graph :

<LegendText  fontSizeAbsolute=”false”/>

<O1TickLabel fontSizeAbsolute=”false”/>

<Y1TickLabel fontSizeAbsolute=”false”/>

 

Ø      To give custom colors to series items (vertical bars)

<SeriesItems>

<Series id=”0″ markerType=”MT_BAR” color=”#993366″/>

<Series id=”1″ markerType=”MT_BAR” color=”#FFFFCC”/>

<Series id=”2″ markerType=”MT_BAR” color=”#CCFFFF”/>

</SeriesItems>

 

Ø      To extend the major tick outside the plot area

<Y1MajorTick lineColor=”#000000″ tickStyle=”GS_EXTENDED”/>

 

Ø      To show the major tick mark only outside the plot area and not inside

<O1MajorTick visible=”true”  lineColor=”#000000″ tickStyle=”GS_OUT”/>

 

Ø      To fill the plot area with a custom color

<PlotArea fillColor=”#C0C0C0″/>

 

Ø      If the numbers on y-axis are abbreviated like 2M or 2000K instead of 2,000,000 then use the following to remove abbreviation

<Y1Axis>

<ViewFormat scaleFactorUsed=”true” scaleFactor=”SCALEFACTOR_NONE” />

</Y1Axis>

 

Ø      Using if statement and sort conditions

 

<xsl:for-each select=”.//G_CONTRIBUTION_SUMMARY“>

<xsl:sort select=”YEAR“/>

<xsl:if test=”YEAR != ‘past years'”>

<Label><xsl:value-of select=”YEAR“/></Label>

</xsl:if>

</xsl:for-each>

Advertisements
This entry was posted in BI Publisher. Bookmark the permalink.

2 Responses to Tips for displaying the bar chart :

  1. Purnachandra says:

    Hi,
    This is Purnachandra working on OAF, have a doubt on how to rollback the substitutions uploaded to the database.

    Rgds / Purna

    • Sowjanya Bhupathiraju says:

      Hi Purna,

      You can either do it using functional administrator.
      or use jdr_utils.deleteDocument procedure.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s