Bar Chart

Example

  This Chart Canvas chart includes3:

  • Custom theme
  • Series.Bar
  • Minimal attribute settings

<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="Basic Bar Chart" ID="Chart_Bar1" AutoQuicktip="False" IdeDisplayStatus="Collapsed">
  <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="50" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlSalesByCat1XML" XMLFile="NW_SalesByCategory.xml">
      <GroupFilter GroupColumn="CategoryName" DataType="Text" KeepGroupedRows="False">
        <GroupAggregateColumn AggregateColumn="ProductSales" AggregateFunction="Sum" ID="gacProductSales" DataType="Number" />
      </GroupFilter>
    </DataLayer>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" AlignmentHorizontal="Left" />
  <ChartXAxis AxisCaption="Category">
    <AxisLabelStyle FontAngle="30" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Total Sales">
    <ChartTicksAndGrid TickInterval="20000" />
    <AxisLabelStyle Format="###,###" />
  </ChartYAxis>
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="Basic Bar Chart" ID="Chart_Bar1" AutoQuicktip="False" IdeDisplayStatus="Collapsed"> <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="50" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlSalesByCat1XML" XMLFile="NW_SalesByCategory.xml"> <GroupFilter GroupColumn="CategoryName" DataType="Text" KeepGroupedRows="False"> <GroupAggregateColumn AggregateColumn="ProductSales" AggregateFunction="Sum" ID="gacProductSales" DataType="Number" /> </GroupFilter> </DataLayer> </Series> <ChartCaptionStyle FontWeight="Normal" AlignmentHorizontal="Left" /> <ChartXAxis AxisCaption="Category"> <AxisLabelStyle FontAngle="30" /> <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" /> </ChartXAxis> <ChartYAxis AxisCaption="Total Sales"> <ChartTicksAndGrid TickInterval="20000" /> <AxisLabelStyle Format="###,###" /> </ChartYAxis> </ChartCanvas>

  This Chart Canvas chart includes:

  • Custom theme
  • Series.Bar
  • Data formatting
  • Hover Highlighting
  • Drilldown (click data value to drill down)

<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Auto Quicktip and DrillDown" ID="Chart_Bar2" PlotBackgroundColor="Khaki" PlotBackgroundColorTransparency="9" IdeDisplayStatus="Collapsed">
  <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="50" HoverBrightness="6" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlSalesByCat2XML" 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>
    <Action Type="Report" ID="actDrillDown" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" />
      <LinkParams PassedData="@Chart.CategoryName~" />
    </Action>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" />
  <ChartXAxis AxisCaption="Category" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontColor="Green" FontFamily="Arial" FontSize="16" FontWeight="Bold" />
    <AxisLabelStyle FontAngle="30" FontColor="Green" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Total Sales" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontSize="18" FontWeight="Bold" />
    <AxisLabelStyle Format="$###,###" />
    <ChartTicksAndGrid TickInterval="20000" />
  </ChartYAxis>
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Auto Quicktip and DrillDown" ID="Chart_Bar2" PlotBackgroundColor="Khaki" PlotBackgroundColorTransparency="9" IdeDisplayStatus="Collapsed"> <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="50" HoverBrightness="6" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlSalesByCat2XML" 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> <Action Type="Report" ID="actDrillDown" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" /> <LinkParams PassedData="@Chart.CategoryName~" /> </Action> </Series> <ChartCaptionStyle FontWeight="Normal" /> <ChartXAxis AxisCaption="Category" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontColor="Green" FontFamily="Arial" FontSize="16" FontWeight="Bold" /> <AxisLabelStyle FontAngle="30" FontColor="Green" /> <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" /> </ChartXAxis> <ChartYAxis AxisCaption="Total Sales" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontSize="18" FontWeight="Bold" /> <AxisLabelStyle Format="$###,###" /> <ChartTicksAndGrid TickInterval="20000" /> </ChartYAxis> </ChartCanvas>

  This Chart Canvas chart includes:

  • Custom theme
  • Series.Bar
  • Minimal attribute settings
  • Input Selection.Point for data selection

<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Input Selection" ID="Chart_Bar8" AutoQuicktip="False" ChartSubCaption="( select one or more bars then click arrow)" IdeDisplayStatus="Collapsed">
  <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="50" Color="LightSalmon" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlSalesByCat8XML" 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>
    <InputSelection Type="Point" ID="inpBars" IdeDisplayStatus="Collapsed">
      <InputSelectionStyle Color="LightCoral" BorderThickness="2" BorderColor="Maroon" />
    </InputSelection>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" />
  <ChartSubCaptionStyle FontWeight="Normal" FontSize="16" />
  <ChartXAxis AxisCaption="Category" IdeDisplayStatus="Collapsed">
    <AxisLabelStyle FontAngle="30" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Total Sales" IdeDisplayStatus="Collapsed">
    <ChartTicksAndGrid TickInterval="20000" />
    <AxisLabelStyle Format="###,###" />
  </ChartYAxis>
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Input Selection" ID="Chart_Bar8" AutoQuicktip="False" ChartSubCaption="( select one or more bars then click arrow)" IdeDisplayStatus="Collapsed"> <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="50" Color="LightSalmon" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlSalesByCat8XML" 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> <InputSelection Type="Point" ID="inpBars" IdeDisplayStatus="Collapsed"> <InputSelectionStyle Color="LightCoral" BorderThickness="2" BorderColor="Maroon" /> </InputSelection> </Series> <ChartCaptionStyle FontWeight="Normal" /> <ChartSubCaptionStyle FontWeight="Normal" FontSize="16" /> <ChartXAxis AxisCaption="Category" IdeDisplayStatus="Collapsed"> <AxisLabelStyle FontAngle="30" /> <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" /> </ChartXAxis> <ChartYAxis AxisCaption="Total Sales" IdeDisplayStatus="Collapsed"> <ChartTicksAndGrid TickInterval="20000" /> <AxisLabelStyle Format="###,###" /> </ChartYAxis> </ChartCanvas>

  This Chart Canvas chart includes:

  • Custom theme
  • Series.Bar
  • Minimal attribute settings

<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Forecasting and DrillDown" PlotBackgroundColorTransparency="9" IdeDisplayStatus="Collapsed" ID="Chart_Bar4">
  <Series Type="Bar" ChartYDataColumn="gacFreight" ChartXDataColumn="fcFDQ" Color="#F7941D,#FDF341,#AED434,#74D6F1,#428BBA,#9894E2,#D08FD1,#DD5766,#98CB00,#F26D7D,#616CA1,#589D47,#F6ED85,#F7943E,#333333" BarThickness="40" Transparency="4" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" XMLFile="NW_Orders.xml" ID="dlOrders3XML" IdeDisplayStatus="Collapsed">
      <TimePeriodColumn ID="tpcFDQ" DataColumn="OrderDate" TimePeriod="FirstDayOfQuarter" DateGroupByOperator="FirstDayOfQuarter" DataType="Date" />
      <GroupFilter GroupColumn="tpcFDQ" DataType="Text" KeepGroupedRows="False" IdeDisplayStatus="Collapsed">
        <GroupAggregateColumn ID="gacFreight" AggregateColumn="Freight" AggregateFunction="Sum" DataType="Number" />
      </GroupFilter>
      <Forecast ID="forecastRegression" Type="Regression" IndependentDataColumn="tpcFDQ" DependentDataColumn="gacFreight" ForecastIndicatorColumnID="forecastIndicator" RegressionType="Linear" ForecastValueColumnID="forecastValue" />
      <FormattedColumn DataColumn="gacFreight" Format="Currency" ID="fmtFreight" />
      <FormattedColumn ID="fcFDQ" DataColumn="tpcFDQ" Format="Qqq yyyy" />
    </DataLayer>
    <Action Type="Report" ID="actDrillDown" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" />
      <LinkParams PassedData="@Chart.tpcFDQ~" />
    </Action>
    <Quicktip IdeDisplayStatus="Collapsed">
      <QuicktipRow Caption="Quarter: " Value="@Chart.fcFDQ~" />
      <QuicktipRow Caption="Freight:" Value="@Chart.gacFreight~" Format="$###,###" />
    </Quicktip>
  </Series>
  <Series Type="Line" ChartYDataColumn="forecastValue" SeriesLineStyle="Dash" Color="Red" ID="Series.Line_Forecast" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" XMLFile="NW_Orders.xml" ID="dlOrders3XML" IdeDisplayStatus="Collapsed">
      <TimePeriodColumn ID="tpcFDQ" DataColumn="OrderDate" TimePeriod="FirstDayOfQuarter" DateGroupByOperator="FirstDayOfQuarter" DataType="Date" />
      <GroupFilter GroupColumn="tpcFDQ" DataType="Text" KeepGroupedRows="False" IdeDisplayStatus="Collapsed">
        <GroupAggregateColumn ID="gacFreight" AggregateColumn="Freight" AggregateFunction="Sum" DataType="Number" />
      </GroupFilter>
      <Forecast ID="forecastRegression" Type="Regression" IndependentDataColumn="tpcFDQ" DependentDataColumn="gacFreight" ForecastIndicatorColumnID="forecastIndicator" RegressionType="Linear" ForecastValueColumnID="forecastValue" />
      <FormattedColumn DataColumn="gacFreight" Format="Currency" ID="fmtFreight" />
      <FormattedColumn ID="fcFDQ" DataColumn="tpcFDQ" Format="Qqq yyyy" />
    </DataLayer>
    <Quicktip IdeDisplayStatus="Collapsed">
      <QuicktipRow Caption="Quarter: " Value="@Chart.fcFDQ~" />
      <QuicktipRow Caption="Forecast" Value="@Chart.forecastValue~" Format="$###,###" />
    </Quicktip>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" FontFamily="Bookman Old Style" />
  <ChartXAxis AxisCaption="Order Date by Quarter" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontColor="CadetBlue" FontFamily="Arial" FontSize="16" FontWeight="Bold" />
    <AxisLabelStyle FontAngle="30" FontColor="CadetBlue" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineColor="Silver" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Freight $" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontSize="16" FontWeight="Bold" />
    <AxisLabelStyle Format="###,###" />
    <ChartTicksAndGrid TickInterval="2000" />
  </ChartYAxis>
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Forecasting and DrillDown" PlotBackgroundColorTransparency="9" IdeDisplayStatus="Collapsed" ID="Chart_Bar4"> <Series Type="Bar" ChartYDataColumn="gacFreight" ChartXDataColumn="fcFDQ" Color="#F7941D,#FDF341,#AED434,#74D6F1,#428BBA,#9894E2,#D08FD1,#DD5766,#98CB00,#F26D7D,#616CA1,#589D47,#F6ED85,#F7943E,#333333" BarThickness="40" Transparency="4" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" XMLFile="NW_Orders.xml" ID="dlOrders3XML" IdeDisplayStatus="Collapsed"> <TimePeriodColumn ID="tpcFDQ" DataColumn="OrderDate" TimePeriod="FirstDayOfQuarter" DateGroupByOperator="FirstDayOfQuarter" DataType="Date" /> <GroupFilter GroupColumn="tpcFDQ" DataType="Text" KeepGroupedRows="False" IdeDisplayStatus="Collapsed"> <GroupAggregateColumn ID="gacFreight" AggregateColumn="Freight" AggregateFunction="Sum" DataType="Number" /> </GroupFilter> <Forecast ID="forecastRegression" Type="Regression" IndependentDataColumn="tpcFDQ" DependentDataColumn="gacFreight" ForecastIndicatorColumnID="forecastIndicator" RegressionType="Linear" ForecastValueColumnID="forecastValue" /> <FormattedColumn DataColumn="gacFreight" Format="Currency" ID="fmtFreight" /> <FormattedColumn ID="fcFDQ" DataColumn="tpcFDQ" Format="Qqq yyyy" /> </DataLayer> <Action Type="Report" ID="actDrillDown" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" /> <LinkParams PassedData="@Chart.tpcFDQ~" /> </Action> <Quicktip IdeDisplayStatus="Collapsed"> <QuicktipRow Caption="Quarter: " Value="@Chart.fcFDQ~" /> <QuicktipRow Caption="Freight:" Value="@Chart.gacFreight~" Format="$###,###" /> </Quicktip> </Series> <Series Type="Line" ChartYDataColumn="forecastValue" SeriesLineStyle="Dash" Color="Red" ID="Series.Line_Forecast" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" XMLFile="NW_Orders.xml" ID="dlOrders3XML" IdeDisplayStatus="Collapsed"> <TimePeriodColumn ID="tpcFDQ" DataColumn="OrderDate" TimePeriod="FirstDayOfQuarter" DateGroupByOperator="FirstDayOfQuarter" DataType="Date" /> <GroupFilter GroupColumn="tpcFDQ" DataType="Text" KeepGroupedRows="False" IdeDisplayStatus="Collapsed"> <GroupAggregateColumn ID="gacFreight" AggregateColumn="Freight" AggregateFunction="Sum" DataType="Number" /> </GroupFilter> <Forecast ID="forecastRegression" Type="Regression" IndependentDataColumn="tpcFDQ" DependentDataColumn="gacFreight" ForecastIndicatorColumnID="forecastIndicator" RegressionType="Linear" ForecastValueColumnID="forecastValue" /> <FormattedColumn DataColumn="gacFreight" Format="Currency" ID="fmtFreight" /> <FormattedColumn ID="fcFDQ" DataColumn="tpcFDQ" Format="Qqq yyyy" /> </DataLayer> <Quicktip IdeDisplayStatus="Collapsed"> <QuicktipRow Caption="Quarter: " Value="@Chart.fcFDQ~" /> <QuicktipRow Caption="Forecast" Value="@Chart.forecastValue~" Format="$###,###" /> </Quicktip> </Series> <ChartCaptionStyle FontWeight="Normal" FontFamily="Bookman Old Style" /> <ChartXAxis AxisCaption="Order Date by Quarter" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontColor="CadetBlue" FontFamily="Arial" FontSize="16" FontWeight="Bold" /> <AxisLabelStyle FontAngle="30" FontColor="CadetBlue" /> <ChartTicksAndGrid TickmarkPlacement="Center" GridLineColor="Silver" /> </ChartXAxis> <ChartYAxis AxisCaption="Freight $" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontSize="16" FontWeight="Bold" /> <AxisLabelStyle Format="###,###" /> <ChartTicksAndGrid TickInterval="2000" /> </ChartYAxis> </ChartCanvas>

  This Chart Canvas chart includes:

  • Custom theme
  • Series.Bar
  • "Horizontal" Chart Canvas orientation
  • Data formatting, with Metric Prefix
  • Hover Highlighting
  • Resizer (hover to see resizing handles)
  • Drilldown (click a bar to drill down)

<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...Horizontal with Resizer and DrillDown" ID="Chart_Bar5" PlotBackgroundColorTransparency="9" ChartOrientation="SwapAxes" PlotBorderColor="Silver" IdeDisplayStatus="Collapsed">
  <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="23" Color="#F7941D,#FDF341,#AED434,#74D6F1,#428BBA,#9894E2,#D08FD1,#DD5766,#98CB00,#F26D7D,#616CA1,#589D47,#F6ED85,#F7943E,#333333" Transparency="2" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlSalesByCat4XML" 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>
    <Action Type="Report" ID="actDrillDown" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" />
      <LinkParams PassedData="@Chart.CategoryName~" />
    </Action>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" />
  <ChartXAxis AxisCaption="Category" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontColor="SteelBlue" FontFamily="Arial" FontSize="16" FontWeight="Bold" />
    <AxisLabelStyle FontColor="SteelBlue" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Sales" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontSize="20" FontWeight="Bold" FontFamily="Calibri" />
    <AxisLabelStyle Format="$#mp" FontAngle="30" />
    <ChartTicksAndGrid TickInterval="10000" TickLineThickness="1" />
  </ChartYAxis>
  <Resizer />
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...Horizontal with Resizer and DrillDown" ID="Chart_Bar5" PlotBackgroundColorTransparency="9" ChartOrientation="SwapAxes" PlotBorderColor="Silver" IdeDisplayStatus="Collapsed"> <Series Type="Bar" ChartYDataColumn="gacProductSales" ChartXDataColumn="CategoryName" BarThickness="23" Color="#F7941D,#FDF341,#AED434,#74D6F1,#428BBA,#9894E2,#D08FD1,#DD5766,#98CB00,#F26D7D,#616CA1,#589D47,#F6ED85,#F7943E,#333333" Transparency="2" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlSalesByCat4XML" 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> <Action Type="Report" ID="actDrillDown" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" /> <LinkParams PassedData="@Chart.CategoryName~" /> </Action> </Series> <ChartCaptionStyle FontWeight="Normal" /> <ChartXAxis AxisCaption="Category" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontColor="SteelBlue" FontFamily="Arial" FontSize="16" FontWeight="Bold" /> <AxisLabelStyle FontColor="SteelBlue" /> <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" /> </ChartXAxis> <ChartYAxis AxisCaption="Sales" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontSize="20" FontWeight="Bold" FontFamily="Calibri" /> <AxisLabelStyle Format="$#mp" FontAngle="30" /> <ChartTicksAndGrid TickInterval="10000" TickLineThickness="1" /> </ChartYAxis> <Resizer /> </ChartCanvas>

  This Chart Canvas chart includes:

  • Custom theme
  • Two Bar series, stacked side-by-side
  • Legend filtering (click Legend item to toggle)
  • Drilldown (click a bar to drill down)

<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Multiple Data Series and Legend Filtering" ID="Chart_Bar6" PlotBackgroundImage="BGLogiSwirl.png" AutoQuicktip="False">
  <Note Note="This datalayer's data available to all child series" />
  <DataLayer Type="XMLFile" ID="dlSalesDataXML" XMLFile="NW_SalesTotalsByAmount.xml" IdeDisplayStatus="Collapsed">
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedMonthAbbrev" TimePeriod="MonthAbbreviation" />
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedMonth" TimePeriod="Month" />
    <GroupFilter GroupColumn="tpcShippedMonth" DataType="Number" KeepGroupedRows="False" SortSequence="Ascending" IdeDisplayStatus="Collapsed">
      <GroupAggregateColumn AggregateColumn="SaleAmount" AggregateFunction="Sum" DataType="Number" ID="gacSalesAmount" />
    </GroupFilter>
    <CalculatedColumn Formula=".20 * " ID="calcSalesTax" />
    <FormattedColumn DataColumn="gacSalesAmount" Format="Currency" ID="fmtSalesAmount" />
    <FormattedColumn DataColumn="calcSalesTax" Format="Currency" ID="fmtSalesTax" />
    <SortFilter SortColumn="tpcShippedMonth" DataType="Number" />
  </DataLayer>
  <Series Type="Bar" ChartYDataColumn="gacSalesAmount" ChartXDataColumn="tpcShippedMonthAbbrev" LegendLabel="Sales" Color="MediumAquamarine" ID="Series.BarSales" BarThickness="15" IdeDisplayStatus="Collapsed">
    <Action Type="Report" ID="actDrillDown1" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" />
      <LinkParams PassedData="Sales: @Chart.gacSalesAmount~" />
    </Action>
  </Series>
  <Series Type="Bar" ChartYDataColumn="calcSalesTax" ChartXDataColumn="tpcShippedMonthAbbrev" LegendLabel="Tax" Color="DarkSalmon" ID="Series.BarTax" BarThickness="15" IdeDisplayStatus="Collapsed">
    <Action Type="Report" ID="actDrillDown2" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" />
      <LinkParams PassedData="Sales Tax: @Chart.calcSalesTax~" />
    </Action>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" FontFamily="Tahoma" FontColor="SteelBlue" />
  <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontWeight="Bold" />
    <AxisLabelStyle FontAngle="30" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Revenue" IdeDisplayStatus="Collapsed" ScaleLowerBound="0" ScaleUpperBound="55000">
    <AxisCaptionStyle FontSize="16" FontWeight="Bold" FontFamily="Arial" />
    <AxisLabelStyle Format="$###,###" />
    <ChartTicksAndGrid TickInterval="5000" />
  </ChartYAxis>
  <ChartCanvasLegend LegendOrientation="Vertical" BorderColor="Silver" OffsetY="42" IdeDisplayStatus="Collapsed">
    <LegendLabelStyle FontSize="12" />
  </ChartCanvasLegend>
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Multiple Data Series and Legend Filtering" ID="Chart_Bar6" PlotBackgroundImage="BGLogiSwirl.png" AutoQuicktip="False"> <Note Note="This datalayer's data available to all child series" /> <DataLayer Type="XMLFile" ID="dlSalesDataXML" XMLFile="NW_SalesTotalsByAmount.xml" IdeDisplayStatus="Collapsed"> <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedMonthAbbrev" TimePeriod="MonthAbbreviation" /> <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedMonth" TimePeriod="Month" /> <GroupFilter GroupColumn="tpcShippedMonth" DataType="Number" KeepGroupedRows="False" SortSequence="Ascending" IdeDisplayStatus="Collapsed"> <GroupAggregateColumn AggregateColumn="SaleAmount" AggregateFunction="Sum" DataType="Number" ID="gacSalesAmount" /> </GroupFilter> <CalculatedColumn Formula=".20 * " ID="calcSalesTax" /> <FormattedColumn DataColumn="gacSalesAmount" Format="Currency" ID="fmtSalesAmount" /> <FormattedColumn DataColumn="calcSalesTax" Format="Currency" ID="fmtSalesTax" /> <SortFilter SortColumn="tpcShippedMonth" DataType="Number" /> </DataLayer> <Series Type="Bar" ChartYDataColumn="gacSalesAmount" ChartXDataColumn="tpcShippedMonthAbbrev" LegendLabel="Sales" Color="MediumAquamarine" ID="Series.BarSales" BarThickness="15" IdeDisplayStatus="Collapsed"> <Action Type="Report" ID="actDrillDown1" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" /> <LinkParams PassedData="Sales: @Chart.gacSalesAmount~" /> </Action> </Series> <Series Type="Bar" ChartYDataColumn="calcSalesTax" ChartXDataColumn="tpcShippedMonthAbbrev" LegendLabel="Tax" Color="DarkSalmon" ID="Series.BarTax" BarThickness="15" IdeDisplayStatus="Collapsed"> <Action Type="Report" ID="actDrillDown2" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" /> <LinkParams PassedData="Sales Tax: @Chart.calcSalesTax~" /> </Action> </Series> <ChartCaptionStyle FontWeight="Normal" FontFamily="Tahoma" FontColor="SteelBlue" /> <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontWeight="Bold" /> <AxisLabelStyle FontAngle="30" /> <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" /> </ChartXAxis> <ChartYAxis AxisCaption="Revenue" IdeDisplayStatus="Collapsed" ScaleLowerBound="0" ScaleUpperBound="55000"> <AxisCaptionStyle FontSize="16" FontWeight="Bold" FontFamily="Arial" /> <AxisLabelStyle Format="$###,###" /> <ChartTicksAndGrid TickInterval="5000" /> </ChartYAxis> <ChartCanvasLegend LegendOrientation="Vertical" BorderColor="Silver" OffsetY="42" IdeDisplayStatus="Collapsed"> <LegendLabelStyle FontSize="12" /> </ChartCanvasLegend> </ChartCanvas>

  This Chart Canvas chart includes:

  • Custom theme
  • Two Bar series, stacked one atop the other
  • Data labels
  • Legend filtering (click Legend item to toggle)
  • Drilldown (click a bar to drill down)

<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Stacked Bars and DrillDown" ID="Chart_Bar6" AutoQuicktip="False" IdeDisplayStatus="Collapsed">
  <Note Note="This datalayer's data available to all child series" />
  <DataLayer Type="XMLFile" ID="dlSalesByCat4XML" XMLFile="NW_SalesByCategory.xml" IdeDisplayStatus="Collapsed">
    <CalculatedColumn Formula="Int( * .20)" 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.BarSales2" BarThickness="45" BarStacking="Stacked" StackGroupName="Stack1" IdeDisplayStatus="Collapsed">
    <DataLabels Format="###,###" FontSize="11" FontColor="White" />
    <Action Type="Report" ID="actDrillDown1" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" />
      <LinkParams PassedData="Sales: @Chart.fmtProductSales~" />
    </Action>
  </Series>
  <Series Type="Bar" ChartYDataColumn="gacSalesTax" ChartXDataColumn="CategoryName" LegendLabel="Tax" Color="DarkOrange" ID="Series.BarTax2" BarThickness="45" BarStacking="Stacked" StackGroupName="Stack1" IdeDisplayStatus="Collapsed">
    <DataLabels Format="###,###" FontSize="11" />
    <Action Type="Report" ID="actDrillDown2" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" />
      <LinkParams PassedData="Sales Tax: @Chart.fmtSalesTax~" />
    </Action>
  </Series>
  <ChartCaptionStyle FontWeight="Normal" />
  <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontWeight="Bold" />
    <AxisLabelStyle FontAngle="30" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Revenue" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontSize="16" FontWeight="Bold" FontFamily="Arial" />
    <AxisLabelStyle Format="$###,###" />
    <ChartTicksAndGrid TickInterval="20000" />
  </ChartYAxis>
  <ChartCanvasLegend LegendOrientation="Vertical" BorderColor="Silver" OffsetY="42" IdeDisplayStatus="Collapsed">
    <LegendLabelStyle FontSize="12" />
  </ChartCanvasLegend>
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="640" ChartCaption="...with Stacked Bars and DrillDown" ID="Chart_Bar6" AutoQuicktip="False" IdeDisplayStatus="Collapsed"> <Note Note="This datalayer's data available to all child series" /> <DataLayer Type="XMLFile" ID="dlSalesByCat4XML" XMLFile="NW_SalesByCategory.xml" IdeDisplayStatus="Collapsed"> <CalculatedColumn Formula="Int( * .20)" 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.BarSales2" BarThickness="45" BarStacking="Stacked" StackGroupName="Stack1" IdeDisplayStatus="Collapsed"> <DataLabels Format="###,###" FontSize="11" FontColor="White" /> <Action Type="Report" ID="actDrillDown1" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" /> <LinkParams PassedData="Sales: @Chart.fmtProductSales~" /> </Action> </Series> <Series Type="Bar" ChartYDataColumn="gacSalesTax" ChartXDataColumn="CategoryName" LegendLabel="Tax" Color="DarkOrange" ID="Series.BarTax2" BarThickness="45" BarStacking="Stacked" StackGroupName="Stack1" IdeDisplayStatus="Collapsed"> <DataLabels Format="###,###" FontSize="11" /> <Action Type="Report" ID="actDrillDown2" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="ChartCanvas.DrillDownTarget" ID="trgDrillDown" /> <LinkParams PassedData="Sales Tax: @Chart.fmtSalesTax~" /> </Action> </Series> <ChartCaptionStyle FontWeight="Normal" /> <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontWeight="Bold" /> <AxisLabelStyle FontAngle="30" /> <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" /> </ChartXAxis> <ChartYAxis AxisCaption="Revenue" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontSize="16" FontWeight="Bold" FontFamily="Arial" /> <AxisLabelStyle Format="$###,###" /> <ChartTicksAndGrid TickInterval="20000" /> </ChartYAxis> <ChartCanvasLegend LegendOrientation="Vertical" BorderColor="Silver" OffsetY="42" IdeDisplayStatus="Collapsed"> <LegendLabelStyle FontSize="12" /> </ChartCanvasLegend> </ChartCanvas>

  This Chart Canvas chart includes:

  • Custom theme
  • Series.Bar Range
  • Custom Quicktip

<ChartCanvas ChartHeight="400" ChartWidth="600" BorderColor="Silver" PlotBorderColor="Silver" SpacingBottom="30" SpacingRight="30" ID="Chart_BarRange" ChartCaption="... with Bar Range Series" PlotBackgroundColor="AliceBlue" IdeDisplayStatus="Collapsed">
  <Series Type="BarRange" ChartHighValueDataColumn="High" ChartLowValueDataColumn="Low" ChartXDataColumn="DayOfMonth" Color="LightSalmon" BarBorderColor="Brown" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" XMLFile="AppleStockJune2013.xml" ID="dlStock13XML" />
    <Quicktip IdeDisplayStatus="Collapsed" Description="Apple Stock Prices">
      <QuicktipRow Caption="June: " Value="@Chart.DayOfMonth~" />
      <QuicktipRow Caption="Low:" Value="@Chart.Low~" Format="Currency" />
      <QuicktipRow Caption="High:" Value="@Chart.High~" Format="Currency" />
    </Quicktip>
  </Series>
  <ChartCaptionStyle FontFamily="Segoe UI" FontSize="22" FontWeight="Normal" OffsetY="20" />
  <ChartXAxis AxisCaption="Day of the Month" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontWeight="Bold" />
    <ChartTicksAndGrid TickInterval="1" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Dollars" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontWeight="Bold" />
  </ChartYAxis>
</ChartCanvas>
<ChartCanvas ChartHeight="400" ChartWidth="600" BorderColor="Silver" PlotBorderColor="Silver" SpacingBottom="30" SpacingRight="30" ID="Chart_BarRange" ChartCaption="... with Bar Range Series" PlotBackgroundColor="AliceBlue" IdeDisplayStatus="Collapsed"> <Series Type="BarRange" ChartHighValueDataColumn="High" ChartLowValueDataColumn="Low" ChartXDataColumn="DayOfMonth" Color="LightSalmon" BarBorderColor="Brown" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" XMLFile="AppleStockJune2013.xml" ID="dlStock13XML" /> <Quicktip IdeDisplayStatus="Collapsed" Description="Apple Stock Prices"> <QuicktipRow Caption="June: " Value="@Chart.DayOfMonth~" /> <QuicktipRow Caption="Low:" Value="@Chart.Low~" Format="Currency" /> <QuicktipRow Caption="High:" Value="@Chart.High~" Format="Currency" /> </Quicktip> </Series> <ChartCaptionStyle FontFamily="Segoe UI" FontSize="22" FontWeight="Normal" OffsetY="20" /> <ChartXAxis AxisCaption="Day of the Month" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontWeight="Bold" /> <ChartTicksAndGrid TickInterval="1" GridLineThickness="0" /> </ChartXAxis> <ChartYAxis AxisCaption="Dollars" IdeDisplayStatus="Collapsed"> <AxisCaptionStyle FontWeight="Bold" /> </ChartYAxis> </ChartCanvas>