Combined Charts

Example

This Chart Canvas chart includes:

Custom theme
Series.Bar element
Two Series.Area elements
Secondary Y-Axis
Caption and Label styling
Legend Filtering (click Legend item to toggle)

<ChartCanvas ID="Chart_Combo1" ChartCaption="Combined Area &amp; Bar Charts" ChartHeight="400" ChartWidth="750" IdeDisplayStatus="Collapsed">
  <Note Note="Both series use same data, so datalayer can be under Chart Canvas element" />
  <DataLayer Type="XMLFile" ID="dlSalesInfo1XML" XMLFile="NW_SalesTotalsByAmount.xml" IdeDisplayStatus="Collapsed">
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonthAbbrev" TimePeriod="MonthAbbreviation" />
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonthNo" TimePeriod="Month" />
    <CalculatedColumn Formula=" * .513" ID="calcSalesTax" />
    <GroupFilter GroupColumn="tpcShipMonthNo" DataType="Number" KeepGroupedRows="False" IdeDisplayStatus="Collapsed">
      <GroupAggregateColumn AggregateColumn="SaleAmount" AggregateFunction="Sum" ID="gacSalesAmount" DataType="Number" />
      <GroupAggregateColumn AggregateColumn="calcSalesTax" AggregateFunction="Sum" ID="gacSalesTax" DataType="Number" />
      <GroupAggregateColumn AggregateColumn="OrderID" AggregateFunction="DistinctCount" ID="gacItemCount" DataType="Number" />
    </GroupFilter>
    <FormattedColumn DataColumn="gacSalesAmount" Format="Currency" ID="fmtSalesAmount" />
    <FormattedColumn DataColumn="gacSalesTax" Format="Currency" ID="fmtSalesTax" />
  </DataLayer>
  <Series Type="Bar" ID="Series.Bar1" ChartYDataColumn="gacItemCount" ChartXDataColumn="tpcShipMonthAbbrev" Color="Goldenrod" LinkedToYAxisID="Y-AxisRight" BarThickness="40" LegendLabel="Orders" />
  <Series Type="Area" ChartYDataColumn="gacSalesAmount" ChartXDataColumn="tpcShipMonthAbbrev" ID="Series.Area1" LinkedToYAxisID="Y-AxisLeft" Color="Gray" Transparency="9" LegendLabel="Sales" />
  <Series Type="Area" ChartYDataColumn="gacSalesTax" ChartXDataColumn="tpcShipMonthAbbrev" ID="Series.Area1a" Color="Coral" LinkedToYAxisID="Y-AxisLeft" Transparency="5" LegendLabel="Sales Tax" />
  <ChartCaptionStyle FontFamily="Segoe UI" FontSize="28" FontWeight="Normal" AlignmentHorizontal="Left" />
  <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontSize="16" />
    <AxisLabelStyle OffsetY="20" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <Note Note="Multiple Y axes are needed: one left, one right" />
  <ChartYAxis ID="Y-AxisLeft" AxisCaption="Dollars" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontSize="16" />
    <AxisLabelStyle Format="###,###" />
    <ChartTicksAndGrid GridLineColor="Silver" GridLineThickness="1" TickInterval="10000" />
  </ChartYAxis>
  <ChartYAxis ID="Y-AxisRight" OppositeSide="True" AxisCaption="Orders" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontColor="Goldenrod" FontSize="16" />
    <AxisLabelStyle />
    <ChartTicksAndGrid GridLineColor="Silver" GridLineThickness="1" TickInterval="2" />
  </ChartYAxis>
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Bar element
Two Series.Line elements
Secondary Y-Axis
Caption and Label styling
Legend Filtering (click Legend item to toggle)

<ChartCanvas ID="Chart_Combo2" ChartCaption="Combined Bar &amp; Line Charts" ChartHeight="400" ChartWidth="750" IdeDisplayStatus="Collapsed">
  <Note Note="Both series use same data, so datalayer can be under Chart Canvas element" />
  <DataLayer Type="XMLFile" ID="dlSalesInfo1XML" XMLFile="NW_SalesTotalsByAmount.xml" IdeDisplayStatus="Collapsed">
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonthAbbrev" TimePeriod="MonthAbbreviation" />
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonthNo" TimePeriod="Month" />
    <CalculatedColumn Formula=" * .513" ID="calcSalesTax" />
    <GroupFilter GroupColumn="tpcShipMonthNo" DataType="Number" KeepGroupedRows="False">
      <GroupAggregateColumn AggregateColumn="SaleAmount" AggregateFunction="Sum" ID="gacSalesAmount" DataType="Number" />
      <GroupAggregateColumn AggregateColumn="calcSalesTax" AggregateFunction="Sum" ID="gacSalesTax" DataType="Number" />
      <GroupAggregateColumn AggregateColumn="OrderID" AggregateFunction="DistinctCount" ID="gacItemCount" DataType="Number" />
    </GroupFilter>
    <FormattedColumn DataColumn="gacSalesAmount" Format="Currency" ID="fmtSalesAmount" />
    <FormattedColumn DataColumn="gacSalesTax" Format="Currency" ID="fmtSalesTax" />
  </DataLayer>
  <Series Type="Bar" ID="Series.Bar1" ChartYDataColumn="gacItemCount" ChartXDataColumn="tpcShipMonthAbbrev" Color="Silver" LinkedToYAxisID="Y-AxisRight" BarThickness="40" LegendLabel="Orders" BarBorderColor="#505050" BarBorderThickness="1" BarBorderRadius="4" BarBorderColorTransparency="7" Transparency="7" />
  <Series Type="Line" ID="Series.Line1" ChartYDataColumn="gacSalesAmount" Color="Orange" LegendLabel="Sales" LinkedToYAxisID="Y-AxisLeft" ChartXDataColumn="tpcShipMonthAbbrev" LineThickness="3" />
  <Series Type="Line" ChartYDataColumn="gacSalesTax" Color="YellowGreen" ID="Series.Line1a" LegendLabel="Sales Tax" LinkedToYAxisID="Y-AxisLeft" ChartXDataColumn="tpcShipMonthAbbrev" />
  <ChartCaptionStyle FontFamily="Segoe UI" FontSize="28" FontWeight="Normal" AlignmentHorizontal="Center" FontColor="DodgerBlue" />
  <ChartXAxis AxisCaption="Month">
    <AxisCaptionStyle FontSize="16" />
    <AxisLabelStyle OffsetY="20" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <Note Note="Multiple Y axes are needed: one left, one right" />
  <ChartYAxis ID="Y-AxisLeft" AxisCaption="Dollars">
    <AxisCaptionStyle FontSize="16" />
    <AxisLabelStyle Format="###,###" />
    <ChartTicksAndGrid GridLineColor="Silver" GridLineThickness="1" TickInterval="10000" />
  </ChartYAxis>
  <ChartYAxis ID="Y-AxisRight" OppositeSide="True" AxisCaption="Orders">
    <AxisCaptionStyle FontColor="#505050" FontSize="16" />
    <AxisLabelStyle />
    <ChartTicksAndGrid GridLineColor="Silver" GridLineThickness="1" TickInterval="2" />
  </ChartYAxis>
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Funnel element
Series.Line element

<ChartCanvas ChartWidth="600" ChartHeight="400" ID="Chart_Combo3" ChartCaption="Combined Funnel and Line Charts" IdeDisplayStatus="Collapsed">
  <Series Type="Funnel" ChartYDataColumn="UnitsInStock" ChartLabelColumn="ProductName" NeckWidth="20%" LabelLocation="NoLabels" Transparency="7">
    <DataLayer Type="XMLFile" ID="dlProductsXML" XMLFile="NW_Products.xml" MaxRows="10">
      <SortFilter SortColumn="UnitsInStock" DataType="Number" SortSequence="Descending" />
    </DataLayer>
  </Series>
  <Series Type="Line" ChartYDataColumn="gacSaleAmount" ChartXDataColumn="tpcShipMonthAbbrev">
    <DataLayer Type="XMLFile" ID="dlSalesDataXML" XMLFile="NW_SalesTotalsByAmount.xml">
      <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonthAbbrev" TimePeriod="MonthAbbreviation" />
      <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonth" TimePeriod="Month" />
      <TimePeriodColumn DataColumn="ShippedDate" ID="tpcMonthName" TimePeriod="MonthName" />
      <GroupFilter GroupColumn="tpcShipMonth" DataType="Number" KeepGroupedRows="False" SortSequence="Ascending">
        <GroupAggregateColumn AggregateColumn="SaleAmount" AggregateFunction="Sum" DataType="Number" ID="gacSaleAmount" />
      </GroupFilter>
    </DataLayer>
  </Series>
  <ChartCaptionStyle FontColor="DarkSeaGreen" FontFamily="Segoe Script" FontSize="28" />
</ChartCanvas>

This Chart Canvas chart includes:

Clarity theme
Series.Pyramid
Series.Line
Auto Quicktips

<ChartCanvas ChartWidth="600" ChartHeight="400" ID="Chart_Combo4" ChartCaption="Combined Pyramid and Line Charts" IdeDisplayStatus="Collapsed">
  <Series Type="Pyramid" ChartYDataColumn="gacProductSales" Transparency="12" ChartLabelColumn="ProductName">
    <DataLayer Type="XMLFile" XMLFile="NW_SalesByCategory.xml">
      <GroupFilter GroupColumn="CategoryName" DataType="Text" KeepGroupedRows="False">
        <GroupAggregateColumn AggregateColumn="ProductSales" AggregateFunction="Sum" ID="gacProductSales" DataType="Number" />
      </GroupFilter>
    </DataLayer>
    <SideLabelStyle FontSize="10" OffsetX="-90" ConnectorThickness="0" FontWeight="Lighter" />
  </Series>
  <Series Type="Line" ChartYDataColumn="gacSaleAmount" ChartXDataColumn="tpcShipMonthAbbrev" Color="RoyalBlue">
    <DataLayer Type="XMLFile" ID="dlSalesDataXML" XMLFile="NW_SalesTotalsByAmount.xml">
      <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonthAbbrev" TimePeriod="MonthAbbreviation" />
      <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShipMonth" TimePeriod="Month" />
      <TimePeriodColumn DataColumn="ShippedDate" ID="tpcMonthName" TimePeriod="MonthName" />
      <GroupFilter GroupColumn="tpcShipMonth" DataType="Number" KeepGroupedRows="False" SortSequence="Ascending">
        <GroupAggregateColumn AggregateColumn="SaleAmount" AggregateFunction="Sum" DataType="Number" ID="gacSaleAmount" />
      </GroupFilter>
    </DataLayer>
  </Series>
  <ChartXAxis>
    <AxisLabelStyle FontSize="11" />
  </ChartXAxis>
  <ChartYAxis>
    <AxisLabelStyle FontSize="10" />
  </ChartYAxis>
  <ChartCaptionStyle FontFamily="Georgia" FontWeight="Lighter" />
</ChartCanvas>