Pyramid Chart

Example

This Chart Canvas chart includes:

Custom theme
Series.Pyramid
Minimal attribute settings

<ChartCanvas ChartHeight="400" ChartWidth="560" ChartCaption="Basic Pyramid Chart" ID="Chart_Pyramid1" AutoQuicktip="False" SpacingRight="80" IdeDisplayStatus="Collapsed">
  <Series Type="Pyramid" ChartYDataColumn="gacProductSales" ChartLabelColumn="ProductName" LabelLocation="SideLayout" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" XMLFile="NW_SalesByCategory.xml" IdeDisplayStatus="Collapsed">
      <GroupFilter GroupColumn="CategoryName" DataType="Text" KeepGroupedRows="False" IdeDisplayStatus="Collapsed">
        <GroupAggregateColumn AggregateColumn="ProductSales" AggregateFunction="Sum" ID="gacProductSales" DataType="Number" />
      </GroupFilter>
    </DataLayer>
  </Series>
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Pyramid
Custom color set
Custom Quicktips

<ChartCanvas ChartHeight="400" ChartWidth="520" ChartCaption="...with custom colors and Quicktips" ID="Chart_Pyramid2" AutoQuicktip="False" SpacingRight="80" IdeDisplayStatus="Collapsed">
  <Series Type="Pyramid" ChartYDataColumn="gacProductSales" ChartLabelColumn="ProductName" LabelLocation="SideLayout" Colors="#AFD8F8,#F6BD0F,#8BBA00,#FF8E46,#008E8E,#D64646,#8E468E,#588526,#B3AA00,#008ED6" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" XMLFile="NW_SalesByCategory.xml" IdeDisplayStatus="Collapsed">
      <GroupFilter GroupColumn="CategoryName" DataType="Text" KeepGroupedRows="False" IdeDisplayStatus="Collapsed">
        <GroupAggregateColumn AggregateColumn="ProductSales" AggregateFunction="Sum" ID="gacProductSales" DataType="Number" />
      </GroupFilter>
    </DataLayer>
    <Quicktip IdeDisplayStatus="Collapsed">
      <QuicktipRow Value="@Chart.ProductName~" Caption="Product: " />
      <QuicktipRow Value="@Chart.gacProductSales~" Caption="Sales:" Format="Currency" />
    </Quicktip>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" />
</ChartCanvas>

This Chart Canvas chart includes:

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

<ChartCanvas ChartWidth="500" ChartHeight="400" ID="Chart_Pyramid3" ChartCaption="...with Legend Filtering, Quicktips" IdeDisplayStatus="Collapsed">
  <Series Type="Pyramid" ChartYDataColumn="gacProductSales" ChartLabelColumn="ProductName" LabelLocation="Legend" Colors="#AFD8F8,#F6BD0F,#8BBA00,#FF8E46,#008E8E,#D64646,#8E468E,#588526,#B3AA00,#008ED6" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" XMLFile="NW_SalesByCategory.xml" IdeDisplayStatus="Collapsed">
      <GroupFilter GroupColumn="CategoryName" DataType="Text" KeepGroupedRows="False" IdeDisplayStatus="Collapsed">
        <GroupAggregateColumn AggregateColumn="ProductSales" AggregateFunction="Sum" ID="gacProductSales" DataType="Number" />
      </GroupFilter>
    </DataLayer>
    <Quicktip IdeDisplayStatus="Collapsed">
      <QuicktipRow Value="@Chart.ProductName~" Caption="Product: " />
      <QuicktipRow Value="@Chart.gacProductSales~" Caption="Sales:" Format="Currency" />
    </Quicktip>
  </Series>
  <ChartCaptionStyle FontSize="22" OffsetY="10" FontFamily="Times New Roman" FontColor="Brown" />
  <ChartCanvasLegend BorderColor="#505050" BackgroundColor="AliceBlue" IdeDisplayStatus="Collapsed">
    <LegendLabelStyle FontFamily="Arial" FontSize="12" />
  </ChartCanvasLegend>
</ChartCanvas>

This Chart Canvas chart includes:

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

<ChartCanvas ChartWidth="500" ChartHeight="510" ID="Chart_Pyramid4" ChartCaption="...with Styled Side Labels" SpacingRight="85" SpacingTop="20">
  <Series Type="Pyramid" ChartYDataColumn="gacProductSales" ChartLabelColumn="ProductName" LabelLocation="SideLayout" Colors="#AFD8F8,#F6BD0F,#8BBA00,#FF8E46,#008E8E,#D64646,#8E468E,#588526,#B3AA00,#008ED6" 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" />
    <Quicktip>
      <QuicktipRow Value="@Chart.ProductName~" Caption="Product: " />
      <QuicktipRow Value="@Chart.gacProductSales~" Caption="Sales:" Format="Currency" />
    </Quicktip>
  </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.Pyramid
Series.Line
Auto Quicktips

<ChartCanvas ChartWidth="640" ChartHeight="500" ID="Chart_Pyramid5" ChartCaption="...with another Series">
  <Series Type="Pyramid" ChartYDataColumn="gacProductSales" ChartLabelColumn="ProductName" Transparency="12">
    <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="14" OffsetX="-90" ConnectorThickness="0" FontWeight="Lighter" FontFamily="Segoe UI" />
  </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="14" FontFamily="Segoe UI" FontWeight="Bold" />
  </ChartXAxis>
  <ChartYAxis>
    <AxisLabelStyle FontSize="14" FontFamily="Segoe UI" />
  </ChartYAxis>
  <ChartCaptionStyle FontWeight="Normal" />
</ChartCanvas>