This discussion is archived
1 Reply Latest reply: Sep 28, 2011 9:37 AM by 524753 RSS

Help with Bar Chart - Word Plugin - Need Y Axis to be 100

Jerry_J Newbie
Currently Being Moderated
So, I have a bar chart that I've created using the Word BI Publisher plugin.
It's very simple, just two bars (for 2010,and 2011), with a number (58 and 42 respectively).

When it creates the bar chart, the Y Axis top level is set to 60.

I'd like it to be 100, so that at first glance you could see that the 2010 value isn't that close to 100

(The numbers in this case represent a percent)

Any ideas how to do that?

Chart XML:


chart:
<Graph stylePath="/oracle/dss/graph/styles/april.xml" depthAngle="50" depthRadius="8" pieDepth="30" pieTilt="20" seriesEffect="SE_AUTO_GRADIENT"><LegendArea visible="false" /><Title text="SW Renewals" visible="true" horizontalAlignment="CENTER" /><Y1Title text="Percent Renewed" visible="true" /><LocalGridData colCount="{count(.//G_SW_RENEWAL_CHART)}" rowCount="1"><ColLabels><xsl:for-each select=".//G_SW_RENEWAL_CHART" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Label><xsl:value-of select="YR2" /></Label></xsl:for-each></ColLabels><DataValues><RowData><xsl:for-each select=".//G_SW_RENEWAL_CHART" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell><xsl:value-of select="PERC" /></Cell></xsl:for-each></RowData></DataValues></LocalGridData></Graph>
  • 1. Re: Help with Bar Chart - Word Plugin - Need Y Axis to be 100
    524753 Guru
    Currently Being Moderated
    Add this code.
    <Graph stylePath="/oracle/dss/graph/styles/april.xml" depthAngle="50" depthRadius="8" pieDepth="30" pieTilt="20" seriesEffect="SE_AUTO_GRADIENT">
    <LegendArea visible="false" />
    <Y1Axis axisMinAutoScaled="false" axisMinValue="0" axisMaxAutoScaled="false" axisMaxValue="100" majorTickStepAutomatic="false" majorTickStep="20"/>
    <Title text="SW Renewals" visible="true" horizontalAlignment="CENTER" />
    <Y1Title text="Percent Renewed" visible="true" />
    <LocalGridData colCount="{count(.//G_SW_RENEWAL_CHART)}" rowCount="1">
    <ColLabels>
    <xsl:for-each select=".//G_SW_RENEWAL_CHART" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <Label><xsl:value-of select="YR2" /></Label>
    </xsl:for-each>
    </ColLabels>
    <DataValues>
    <RowData>
    <xsl:for-each select=".//G_SW_RENEWAL_CHART" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <Cell><xsl:value-of select="PERC" /></Cell></xsl:for-each>
    </RowData></DataValues>
    </LocalGridData>
    </Graph>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points