<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:rs="urn:schemas-microsoft-com:rowset" 
xmlns:z="#RowsetSchema">
<xsl:template match="rs:data">


<chart plotFillRatio='0' caption='Integrated LEI by State' showlabels='0' rotateLabels='1' 
labelDisplay='WRAP' xaxisname="State" yAxisMaxValue="100" yAxisName='I-LEI(%)' showValues='0' numbersuffix='%' >
<trendLines>
<line color='FF0000' valueOnRight='1' showOnTop='1' displayvalue="Average">
 <xsl:attribute name="startValue">
 			<xsl:value-of select="100*(sum(z:row/@*[2]) div count(z:row))"/>
 
 </xsl:attribute>
 </line>
</trendLines><categories>
<xsl:for-each select="z:row[@*[2]!='']">
			<category>
			<xsl:attribute name="label">
			<xsl:value-of select="@ows_State"/>
			</xsl:attribute>
			</category>
      </xsl:for-each>
</categories>

<dataset seriesName='APAC'>
	<xsl:for-each select="z:row">
	<set>
			<xsl:attribute name="value">
			<xsl:if test="@ows_ICAO_x0020_HQ='APAC'">
			<xsl:value-of select="@*[2] * 100"/>
</xsl:if>
			</xsl:attribute>
	</set>
  </xsl:for-each>
</dataset>

<dataset seriesName='EUR/NAT'>
	<xsl:for-each select="z:row">
	<set>
			<xsl:attribute name="value">
			<xsl:if test="@ows_ICAO_x0020_HQ='EUR/NAT'">
			<xsl:value-of select="@*[2] * 100"/>
			</xsl:if>
			</xsl:attribute>
	</set>
  </xsl:for-each>
</dataset>
<dataset seriesName='NACC'>
	<xsl:for-each select="z:row">
	<set>
			<xsl:attribute name="value">
			<xsl:if test="@ows_ICAO_x0020_HQ='NACC'">
			<xsl:value-of select="@*[2] * 100"/>
</xsl:if>
			</xsl:attribute>
	</set>
  </xsl:for-each>
</dataset>

<dataset seriesName='MID'>
	<xsl:for-each select="z:row">
	<set>
			<xsl:attribute name="value">
			<xsl:if test="@ows_ICAO_x0020_HQ='MID'">
			<xsl:value-of select="@*[2] * 100"/>
</xsl:if>
			</xsl:attribute>
	</set>
  </xsl:for-each>
</dataset>

<dataset seriesName='WACAF'>
	<xsl:for-each select="z:row">
	<set>
			<xsl:attribute name="value">
			<xsl:if test="@ows_ICAO_x0020_HQ='WACAF'">
			<xsl:value-of select="@*[2] * 100"/>
</xsl:if>
			</xsl:attribute>
	</set>
  </xsl:for-each>
</dataset>

<dataset seriesName='ESAF'>
	<xsl:for-each select="z:row">
	<set>
			<xsl:attribute name="value">
			<xsl:if test="@ows_ICAO_x0020_HQ='ESAF'">
			<xsl:value-of select="@*[2] * 100"/>
</xsl:if>
			</xsl:attribute>
	</set>
  </xsl:for-each>
</dataset>

<dataset seriesName='SAM'>
	<xsl:for-each select="z:row">
	<set>
			<xsl:attribute name="value">
			<xsl:if test="@ows_ICAO_x0020_HQ='SAM'">
			<xsl:value-of select="@*[2] * 100"/>
</xsl:if>
			</xsl:attribute>
	</set>
  </xsl:for-each>
</dataset>


</chart>
</xsl:template>
</xsl:stylesheet>