Need help to display Graph in RTF Template
Hi,
Iam trying to create a graph in rtf template through Oracle fusion. Below is my expected graph design
Expected Graph Output:
Actual Graph Output: I need to change bars style with spaces between two bars and need to display horizontal grid lines instead of vertical (As exactly as above graph style). Could anyone please help me to achieve this.
Below is the code using to display graph chart:
chart:<Graph graphType = "BAR_VERT_CLUST"><LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_BOTTOM"/><SeriesItems><Series id="0" color"#00534C"/><Series id="1" color="#DC8633"/><Series id="2" color="#A69F88"/></SeriesItems><Y1Title text="$ in millions" visible="true"><GraphFont bold="false" italic="false" underline="false" font-family="Arial" font-size="6.5" fontColor="#000000"/></Y1Title><O1Title text="Division" visible="false"/><LocalGridData colCount="5" rowCount="3"><RowLabels><GraphFont bold="false" italic="false" underline="false" font-family="Arial" font-size="8" fontColor="#000000" /><Label>Actual- <xsl:value-of select=".//G_ENDDATES/END_DATE_FORMATTED"/></Label><Label>Planned- <xsl:value-of select=".//G_ENDDATES/END_DATE_FORMATTED"/> </Label><Label>Actual- <xsl:value-of select=".//G_ENDDATES/LAST_YEAR_DATE_FORMATTED"/></Label></RowLabels><ColLabels><GraphFont bold="false" italic="false" underline="false" font-family="Arial" font-size="5.5" fontColor="#000000" /><Label>Claims Adjusting</Label><Label>Advertising</Label><Label>Employee relations</Label><Label>Equipment</Label><Label>Service-Consulting</Label></ColLabels><DataValues><RowData><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G21']/CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G22']/CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G23']/CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G24']/CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G25']/CURR_YTD"/></Cell></RowData><RowData><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G21']/PLANNED_CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G22']/PLANNED_CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G23']/PLANNED_CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G24']/PLANNED_CURR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G25']/PLANNED_CURR_YTD"/></Cell></RowData><RowData><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G21']/PRIOR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G22']/PRIOR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G23']/PRIOR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G24']/PRIOR_YTD"/></Cell><Cell><xsl:value-of select="//G_EXPDIST[METRIC_CODE = 'G25']/PRIOR_YTD"/></Cell></RowData></DataValues></LocalGridData>