Edit Connect Line - Chart Options
overview     how to     example    see also 

Select connect lines > Editor > Edit Connect Line > Chart Options

Select bar chart > Editor > Graph Options

Use to specify increasing or decreasing bar order, choose a cumulative y-scale, or choose a percent scale for the y-axis. If you have more than one categorical variable, use to specify the grouping level for calculating the scale and to stack data.

Dialog box items

Order Main X Groups By Choose the order for the bars. See Ordering Category Groups Based on Y-Axis Values.

Default: Choose to use the default order for bars based on the variable type: numeric in ascending order, date/time in increasing chronological order, and text in alphabetical order. To change the display order for text categories, see Ordering text categories. For bar charts of values from a table, the default order is always the order in which the categories appear in the worksheet; any value order is ignored.

Increasing Y: Choose to order bars from smallest to largest y-values.

Decreasing Y: Choose to order bars from largest to smallest y-values.

Percent and Accumulate

Show Y as Percent: Check to use a percent scale on the y-axis. See Using Percent Scales and Accumulating Y Across X.

Accumulate Y across X: Check to use a cumulative scale on the y-axis. See Using Percent Scales and Accumulating Y Across X.

Take Percent and/or Accumulate: If you have two or more categorical variables, specify for which grouping level you want to show y as a percent and/or accumulate y across x. The options available depend on the number of categorical variables that are included in the bar chart. For more information, see Using Percent Scales and Accumulating Y Across X.

Across all categories: Choose to apply a percent scale and/or cumulative scale across all categories.

Within categories at level 1 (outermost): Choose to apply a percent scale and/or cumulative scale within categories at the outermost scale level only.

Within categories at level 2: Choose to apply a percent scale and/or cumulative scale within categories at the second grouping level from the bottom only.

Within categories at level 3: Choose to apply a percent scale and/or cumulative scale within categories at the third grouping level from the bottom only.

Stack (Not available with simple bar charts)

Stack innermost groups: Check to stack the categories for the categorical variable closest to the scale. Each category is represented by a separate segment of a bar.

Show First Group At: (Only available with stacked bar charts) Specify how to display categories in a stacked bar chart based on a column's value order.

Top of Stack: Choose to display the first group at the top of the stack and the remaining groups in descending order.

Bottom of Stack: Choose to display the first group at the bottom of the stack and the remaining groups in ascending order.

<Attributes>

<Groups>

<Connect Options>