Skip to main content

Columns/Series

Columns/Series help you organize and compare information visually or in a table. In worksheets, columns run vertically and group similar data, like names or dates. In charts, a series is a set of related data points that represent values for specific categories—such as bars, segments, or points—making it easier to see differences and trends in your data across various types of charts.

The term Columns appears in worksheets and KPI, while Series appears in charts, pies, doughnuts, funnels, maps, tree maps, word cloud, and sparklines.

Any Dimensions, Measures and/or Description can be added to the Columns or Series section. A minimum of one field is required in the Columns section to create a valid view.

Add fields to Columns or Series​

Using the View Organizer​

  1. In the Toolbar panel, select Dimensions and Measures.
  2. Select the fields you want to add. Use Shift to select multiple fields.
  3. Drag the selected fields into the Columns or Series section.

Using the Properties menu​

  1. In the Toolbar panel, select Properties.
  2. In the Data tab, expand the Columns or Series section.
  3. Click the Select Columns or Select Series dropdown menu, and select the fields to add.
  4. Click Add.

Configure Columns or Series settings​

For dimensions added in the Columns or Series section, several options are available to refine your analysis. Available options may differ depending on the view type.

Sort Order​

The Sort Order setting controls whether group values are arranged in Ascending or Descending order. This helps present your data clearly. By default, values are sorted in Ascending order.

You can set the sort order for a grouped field using either the View Organizer or the Properties menu.

Using the View Organizer​

  1. Right-click a field in the Columns or Series section.
  2. Select Sort Ascending or Sort Descending.

Using the Properties menu​

  1. In the Toolbar panel, select Properties.
  2. In the Data tab, expand the Columns or Series section.
  3. Select and expand the field.
  4. Next to Sort Order, click the ascending or descending icon.