1 Reply Latest reply: Sep 28, 2011 11:37 AM by 524753 RSS

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

    Jerry_J
      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
          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>