Funnel Chart

Example

This Chart Canvas chart includes:

Custom theme
Series.Funnel
Minimal attribute settings

<ChartCanvas ChartHeight="400" ChartWidth="700" ChartCaption="Basic Funnel Chart" ID="Chart_Funnel1" AutoQuicktip="False" SpacingRight="100" IdeDisplayStatus="Collapsed">
  <Series Type="Funnel" ChartYDataColumn="UnitsInStock" ChartLabelColumn="ProductName" NeckWidth="20%" LabelLocation="SideLayout" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlProductsXML" XMLFile="NW_Products.xml" MaxRows="10" IdeDisplayStatus="Collapsed">
      <SortFilter SortColumn="UnitsInStock" DataType="Number" SortSequence="Descending" />
    </DataLayer>
    <SideLabelStyle MaxLabelLength="20" FontSize="11" FontFamily="Arial" />
  </Series>
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Funnel
Custom color set
Custom Quicktips

<ChartCanvas ChartHeight="400" ChartWidth="700" ChartCaption="...with custom colors and Quicktips" ID="Chart_Fun2" AutoQuicktip="False" SpacingRight="100">
  <Series Type="Funnel" ChartYDataColumn="UnitsInStock" ChartLabelColumn="ProductName" NeckWidth="20%" LabelLocation="SideLayout" Colors="#AFD8F8,#F6BD0F,#8BBA00,#FF8E46,#008E8E,#D64646,#8E468E,#588526,#B3AA00,#008ED6">
    <DataLayer Type="XMLFile" ID="dlProductsXML" XMLFile="NW_Products.xml" MaxRows="10">
      <SortFilter SortColumn="UnitsInStock" DataType="Number" SortSequence="Descending" />
    </DataLayer>
    <SideLabelStyle MaxLabelLength="20" FontFamily="Arial" FontSize="11" />
    <Quicktip>
      <QuicktipRow Value="@Chart.ProductName~" Caption="Product: " />
      <QuicktipRow Value="@Chart.UnitsInStock~" Caption="In Stock:" />
    </Quicktip>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" />
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Funnel
Legend Filtering (click Legend item to toggle)
Auto Quicktips

<ChartCanvas ChartWidth="540" ChartHeight="400" ID="Chart_Funnel3" ChartCaption="...with Legend Filtering, Quicktips">
  <Series Type="Funnel" ChartYDataColumn="gacProductSales" ChartLabelColumn="CategoryName" NeckWidth="20%" Colors="#2F7ED8,#0D233A,#8BBC21,#910000,1AADCE,#492970,#F28F43,#77A1E5,#C42525,#A6C96A" LabelLocation="Legend" ID="Series.Funnel_Legend">
    <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 ConnectorStyle="Lines" BorderColor="#505050" BackgroundColor="AliceBlue" FontColor="Maroon" BorderRadius="4" FontFamily="Segoe UI" FontSize="11" />
  </Series>
  <ChartCaptionStyle FontSize="22" OffsetY="10" FontFamily="Times New Roman" FontColor="Brown" />
  <ChartCanvasLegend BorderColor="#505050" BackgroundColor="AliceBlue">
    <LegendLabelStyle FontFamily="Arial" FontSize="12" />
  </ChartCanvasLegend>
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Funnel
Side label layout
Styled labels
Show data values with labels

<ChartCanvas ChartWidth="450" ChartHeight="450" ID="Chart_Fun4" ChartCaption="...with Styled Side Labels" SpacingRight="90" SpacingBottom="30" AutoQuicktip="False">
  <Series Type="Funnel" ChartYDataColumn="gacProductSales" ChartLabelColumn="CategoryName" NeckWidth="20%" Colors="#AFD8F8,#F6BD0F,#8BBA00,#FF8E46,#008E8E,#D64646,#8E468E,#588526,#B3AA00,#008ED6" LabelLocation="SideLayout" ID="Series.Funnel_Labels" ShowDataValues="True" ShowDataValuesFormat="Currency">
    <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 ConnectorStyle="Lines" BorderColor="#505050" BackgroundColor="AliceBlue" FontColor="Maroon" BorderRadius="4" FontFamily="Segoe UI" FontSize="11" />
  </Series>
  <ChartCaptionStyle FontWeight="Normal" FontColor="DarkSeaGreen" />
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Funnel
Series.Line
Auto Quicktips

<ChartCanvas ChartWidth="540" ChartHeight="400" ID="Chart_Funnel5" ChartCaption="...with another Series">
  <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 FontWeight="Normal" />
</ChartCanvas>