Summary

BIP RTF Chart XML issue

Content

Hi,

I am trying to build a bar chart using BIP add-in in MS Word. After I selected values, labels and other properties, the chart populated as expected. But I can't make further change to the chart as XML clumped together? All the options greyed out in Chart Builder tab. Can anyone suggest a fix to this issue? I tried to copy the original XML to Chart Advanced tab, it defaulted to clumped version each time.

XML sould be:

<Graph seriesEffect="SE_AUTO_GRADIENT"><LegendArea visible="false"/>
<Y1TickLabel>
<GraphFont  size="6" bold="false" italic="false" underline="false"/>
</Y1TickLabel>
<O1TickLabel>
<GraphFont  size="6" bold="false" italic="false" underline="false"/>
</O1TickLabel>
<LocalGridData colCount="{count(.//G_1)}" rowCount="1">

<ColLabels><xsl:for-each select=".//G_1"><Label><xsl:value-of select="WEEK"/></Label></xsl:for-each></ColLabels>
<DataValues><RowData><xsl:for-each select=".//G_1"><Cell><xsl:value-of select="MEETING_KPI_PCT"/></Cell></xsl:for-each></RowData></DataValues>
</LocalGridData>
<MarkerText visible="true" markerTextPlace ="MTP_OUTSIDE_MAX"><Y1ViewFormat><ViewFormat decimalDigit="1" decimalDigitUsed="true"/></Y1ViewFormat><GraphFont  size="6" bold="false" italic="false" underline="false"/>
</MarkerText>
</Graph>

XML became this:

<Graph seriesEffect="SE_AUTO_GRADIENT"><LegendArea visible="false" /><Y1TickLabel><GraphFont size="6" bold="false" italic="false" underline="false" /></Y1TickLabel><O1TickLabel><GraphFont size="6" bold="false" italic="false" underline="false" /></O1TickLabel><LocalGridData colCount="{count(.//G_1)}" rowCount="1"><ColLabels><xsl:for-each select=".//G_1" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Label><xsl:value-of select="WEEK" /></Label></xsl:for-each></ColLabels><DataValues><RowData><xsl:for-each select=".//G_1" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell><xsl:value-of select="MEETING_KPI_PCT" /></Cell></xsl:for-each></RowData></DataValues></LocalGridData><MarkerText visible="true" markerTextPlace="MTP_OUTSIDE_MAX"><Y1ViewFormat><ViewFormat decimalDigit="1" decimalDigitUsed="true" /></Y1ViewFormat><GraphFont size="6" bold="false" italic="false" underline="false" /></MarkerText></Graph>