Enter your data for Xbar Chart (Data tab)

On the Data tab of the Xbar Chart dialog box, select the option that best describes your data.

All measurements are in one column

Complete the following steps if the measurement data are in one column.

  1. From the first drop-down list, select Data are in one column for all subgroups.
  2. In Data column, enter a column of measurement data.
  3. From the second drop-down list, do one of the following:
    • If all subgroups are the same size, choose All subgroups are the same size. In Subgroup size, enter the subgroup size (for example, 5).
    • If you have a column of values that identifies which subgroup each measurement is from, choose Subgroup IDs are in a column. In Subgroup ID column, enter the column of subgroup identifiers.
In this worksheet, Length contains the length of parts, and Subgroup contains the subgroup indicators.
C1 C2
Length Subgroup
0.65 1
0.69 1
0.67 1
0.67 1
0.62 2
0.59 2
0.59 2
0.60 2

Measurements for each subgroup are in a different row

Complete the following steps if each row in the worksheet contains the measurement data for one subgroup.

  1. From the drop-down list, select Data are in multiple columns, one row for each subgroup.
  2. In Data columns, enter the columns that contain the measurement data.
In this worksheet, the data for subgroup 1 are in the first row across columns 1−4. The data for subgroup 2 are in the second row across columns 1−4.
C1 C2 C3 C4
Measurement 1 Measurement 2 Measurement 3 Measurement 4
0.65 0.69 0.67 0.67
0.62 0.59 0.59 0.60
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy