Bar Chart Properties

Bar chart properties control the general attributes for the various bar chart formats, including:

  To adjust bar chart properties:

  1. Select Chart, then Properties.

  2. Select the Bar Chart tab.

  3. Modify the properties as desired, and click OK.

Table 89. Bar Chart Properties

Option

Description

Show values on bars

Toggles the display of data values for all bars.

Cluster bars by items in "Y" axis

Uses the item assigned to the y axis to define a bar cluster. For example, if you have "Quarter" on the y axis, each cluster consists of four bars. (clustered bar charts only).

Cluster bars by items in "Z" axis

Uses the item assigned to the z axis to define a bar cluster. For example, if you have "Product Line" on the z axis, each cluster consists of a bar for each product line in your data. (clustered bar charts only).

Table 90. Bar Chart Properties

Option

Description

Show values on bars

Toggles the display of data values for all bar lines.

Show line values

Toggle the display of numeric values on each bar line.

Ignore null values for lines

Ignores null values by not plotting a line to a marker representing null values in the Bar Line or Line chart. Null values can disrupt the appearance of values in a line chart. Zero’s (0) are included.

Shift Points to Left

Places line chart plot points at left of bars (bar-line charts only).

Shift Points to Center

Places line chart plot points centered on bars (bar-line charts only).

Stack bars along "Y" axis

Uses the item assigned to the "Y" axis to define a stacked bar line. For example, if you have "Quarter" on the "Y" axis, each stacked bar line consists of two lines.

Cluster bars along "Y" axis

Uses the item assigned to the "Y" axis to define a bar line cluster. For example, if you have "Quarter" on the "Y" axis, each cluster consists of four lines.