Add Data Bars to Tables and Pivots

In Oracle Analytics, you can add data bars to cells in table and pivot visualizations to provide a visual representation of measure column values.

A data bar represents the numeric values using a horizontal bar where the length corresponds to the value.

For example, to make a table visualization showing the sales numbers for product categories and subcategories more impactful, you can add data bars to the cells displaying the sales values.
Description of data-bars-table-example.png follows
Description of the illustration data-bars-table-example.png

You can configure data bars using the properties available for the measure in the Edge Labels tab of the Properties pane.

Property Description
Chart

Specifies the type of data bar displayed.

Options
  • Standard Bar: Displays a bar whose length is based on the value relative to the configured start and end values.
  • 100% Bar: Displays bars using a fixed length where the colored portion represents the measure value as a percentage of the configured range.
Bar Width

Specifies the width of a 100% Bar.

Options
  • Auto: Automatically determines the bar width.
  • Custom: Lets you specify the bar width.
Show Value

Specifies whether and where the numeric value is displayed.

Options
  • Over Bar: Displays the numeric values in the cells on top of the bar. This is the default for Standard Bar.
  • Before Bar: Displays the numeric value before the bar.
  • After Bar: Displays the numeric value after the bar. This is the default for 100% Bar.
  • None: Displays only the bar and hides the numeric value
Direction

Specifies the direction in which the bar is displayed.

Options
  • Left to Right
  • Right to Left
Color

Specifies the color of the data bar.

Options
  • Auto: Uses a default color based on the workbook theme
  • Custom: Lets you specify a color and the transparency.
Start

Specifies the starting value used to calculate the data bar length.

Options
  • Auto: Starts the data bar at 0, or at the minimum value when the data contains negative values.
  • Min Data: Starts the data bar at the minimum value in the measure data.
  • Custom: Lets you specify a starting value.
End

Specifies the ending value used to calculate the data bar length.

Options
  • Auto: Sets the end value to 0 when the measure contains only negative values. Otherwise, uses the maximum value in the measure data.
  • Max Data: Sets the end value to the maximum value in the measure data.
  • Custom: Lets you specify an ending value.

This tutorial shows you how to add data bars to tables and pivots. Tutorial icon Tutorial

  1. On your home page, hover over a workbook, click Actions, and select Open.
  2. Select your table or pivot visualization.
  3. Click Properties, then click Edge Labels Edge Labels icon.
  4. Expand the measure column you want to add data bars to.
  5. In the Chart row, click None, then select either Standard Bar or 100% Bar.
  6. Use the Chart property options to configure the appearance of the data bars and specify the start and end values.
    Description of vizproperties-table-pivot-data-bars.png follows
    Description of the illustration vizproperties-table-pivot-data-bars.png

  7. Click Save.