Cross Column Chart

A Cross Column Chart object that represents data as a series of grouped vertical columns whose height is determined by the values in the data.

The Cross Column Chart object needs two Dates or Texts columns (or one of each) that will be used to group data and one Value column that will be shown as the columns in the chart.

For other chart options, see Objects.

Example

In the example above, the chart displays the Branch Profit by company Product, showing also the Total column.

The second example displays the Products Net Revenue by Year, also showing the Total column.

See below all available properties for this object:

• Data Properties:
  • Filters
  • Rows Sort
  • Average Column
  • Total Column
  • Total Row
  • Advanced Row Filter
  • Row Limit

• Category Axis Properties:
  • Hide Labels
  • Font Size
  • Abbreviate Labels
  • Hide Category

• Values Axis Properties:
  • Decimals
  • Thousand Separator
  • Maximum Axis Value
  • Minimum Axis Value

• Series Properties:
  • Hide Labels
  • Stacking

• Legend Properties:
  • Hide Legend
  • Legend Position
  • Font Size
  • Abbreviate Legend

• Title Bar Properties:
  • Title Bar Properties

• Layout Properties:
  • Show Border
  • Border Color
  • Background Color
  • Object Positions
  • Object Dimensions

• Column Properties:
  • Column Name
  • Data Type
  • Column Label
  • Column Filters
  • Delete Column
  • Function
  • Decimal Places
  • Thousand Sep.
  • Series Type
  • Mask