<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Stacked Bars and Legend" ID="Chart_Bar3" AutoQuicktip="False" IdeDisplayStatus="Collapsed">
<Note Note="This datalayer's data is available to all child series" />
<DataLayer Type="XMLFile" ID="dlSalesByCat4XML" XMLFile="NW_SalesByCategory.xml" IdeDisplayStatus="Collapsed">
<CalculatedColumn Formula="Int( * .30)" ID="calcSalesTax" />
<GroupFilter GroupColumn="CategoryName" DataType="Text" KeepGroupedRows="False" SortSequence="Descending" IdeDisplayStatus="Collapsed">
<GroupAggregateColumn AggregateColumn="ProductSales" AggregateFunction="Sum" ID="gacProductSales" DataType="Number" />
<GroupAggregateColumn AggregateColumn="calcSalesTax" AggregateFunction="Sum" ID="gacSalesTax" DataType="Number" />
</GroupFilter>
<FormattedColumn DataColumn="gacProductSales" Format="Currency" ID="fmtProductSales" />
<FormattedColumn DataColumn="gacSalesTax" Format="Currency" ID="fmtSalesTax" />
</DataLayer>
<Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" LegendLabel="Sales" Color="#428BBA" ID="Series.BarSales3" BarThickness="45" BarStacking="Stacked" StackGroupName="Stack1" IdeDisplayStatus="Collapsed">
<DataLabels Format="###,###" FontSize="11" FontColor="White" />
</Series>
<Series Type="Bar" ChartYDataColumn="gacSalesTax" ChartXDataColumn="CategoryName" LegendLabel="Tax" Color="DarkSeaGreen" ID="Series.BarTax3" BarThickness="45" BarStacking="Stacked" StackGroupName="Stack1" IdeDisplayStatus="Collapsed">
<DataLabels Format="###,###" FontSize="11" />
</Series>
<ChartCaptionStyle FontWeight="Normal" />
<ChartXAxis IdeDisplayStatus="Collapsed">
<AxisCaptionStyle FontFamily="Arial" FontSize="16" FontWeight="Bold" />
<AxisLabelStyle FontAngle="30" />
<ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
</ChartXAxis>
<ChartCanvasLegend LegendOrientation="Vertical" BorderColor="Silver" OffsetY="42" IdeDisplayStatus="Collapsed">
<LegendLabelStyle FontSize="12" />
</ChartCanvasLegend>
</ChartCanvas>