Previous Topic: Display Graphics in the View

Next Topic: Display a Progress Bar

Display an Attribute as a Bar or Column Chart

Display an attribute as a bar or column chart to represent the values of the attribute visually. Typically, number, formula, or money attributes work well with bar or column charts. For example, you can graphically display the Cost to Date attribute for a project instance.

Follow these steps:

  1. Open Administration, and from Studio, click Objects.
  2. Click the name of the object.
  3. Click Views.
  4. In the Category column, locate the List view and click the [Fields] link in that row.
  5. Click the Properties icon in the row that contains the attribute you want to change.
  6. Complete the requested information depending on the attribute data and display type. The following fields require explanation:
    Display Type

    Specifies the type of chart to display for the attribute. The list of display type values is based on the attribute data type. For example, if the attribute data type is numeric, the display type values are Number, Percent, Calculated Percent, Column Graph, and Bar Graph.

    Secondary Value

    Defines the attribute whose value displays as a secondary value when the user moves a cursor over the primary bar.

    Length Scaling

    Defines the length scaling for the bars in the chart.

    Values:

    • Relative to Same Column. Makes the bar length proportional to other bars in the same column. Select this option when displaying horizontal bars. For example, the Budget Cost bar in a row for $500,000 shows twice as tall as the Budget Cost bar in a row for $250,000.
    • Relative to Same Row. Makes the bar proportional to all other bars in the same row. Select this option when displaying vertical bars. For example, the Budget Cost bar with a value of $500,000 shows twice as tall as the Budget Benefit bar with a value of $250,000.
    • Relative to Entire Table. Makes the bar proportional to all bars of the same type (vertical or horizontal) in the entire table. For example, in a grid with the Budget Cost column as a vertical bar, a row with a Budget Cost of $500,000 appears twice as tall as the Budget Cost of $250,000 in another row.
    • No Scaling. Draws all bars to the maximum length. Select this option to create progress bars.

      For example, you can have an ETC (estimated time of completion) column with actuals as the threshold value. The part under the threshold shows how much work is already done. The part over the threshold shows how much work remains to be done. By looking at a column of these bar charts, you can quickly see how close each task is to being complete relative to the others.

    Color

    Specifies the color for the primary bar.

    Threshold Line Attribute

    Defines the attribute that holds the threshold value. In bar charts, a vertical line marks the threshold value.

    Over-threshold Color

    Defines the color to represent values greater than the threshold value. Any portion of the primary bar that extends past the threshold is drawn in the over-threshold color. Any portion of the secondary bar that extends past the threshold is drawn in a darker shade of the same color.

    Link

    Specifies the page to display when the user clicks the primary bar. To open the page in a pop-up window, select Open as Pop-up.

    Stacked Attribute

    Specifies the attribute to represent as a stacked bar.

    Color

    Specifies the color for the stacked bar.

    Secondary Value

    Specifies the value to display when the user moves a cursor over the secondary bar.

    Link

    Specifies the page to display when the user clicks the secondary bar.

  7. Save your changes.

Back to Top