Home » Categories » CHARTrunner

CR: Making an X-bar chart with a single data column

Revision Date: 2005-09-19

Problem:

Several customers have presented us with data in the following general form:

Date                 Number of days
8/1/2003          12
8/1/2003          11
8/1/2003          9
8/2/2003          8
8/2/2003          10
8/3/2003          11
8/3/2003          9
8/4/2003          8
8/4/2003          10
8/4/2003          7

They want to use this data for an X-bar chart but an X-bar chart requires subgroups of data. A subgroup is two or more numbers (observations) which are used to calculate an average.

Solution:

In this case, subgroups must be created by using multiple rows of data. We have a date we can use for grouping. You might think about this same data set in a different form like this:

8/1/2003          12, 11, 9
8/2/2003          8, 10
8/3/2003          11, 9
8/4/2003          8,10,7

Since the data is not in this handy form, you need to use a CHARTrunner feature called advanced row selection. On the data definition tab, click on the button named advanced row selection.

Unzip the attached file into a temporary folder. Run CHARTrunner and set the working folder to this temporary folder. Study the chart definition and the Excel sheet to see the solution to this problem. Since subgroup size will vary in an unpredictable way, the control limits are adjusted to reflect the changing subgroup size.

Attachments (1) Attachments
Related Articles RSS Feed
CR: Charting counted incidents
Viewed 2190 times since Thu, Feb 23, 2012
CR: Unable to fully display settings and windows
Viewed 2045 times since Fri, Jan 22, 2010
CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
Viewed 3925 times since Fri, Nov 9, 2007
CR: A custom query for Length of Stay data
Viewed 2657 times since Fri, Nov 9, 2007
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2214 times since Fri, Nov 9, 2007
CR: Bar Chart of a column of numbers in various categories
Viewed 2069 times since Fri, Nov 9, 2007
CR: CHARTrunner and Open Office
Viewed 2492 times since Fri, Nov 9, 2007
CR: General Filtering Tips
Viewed 2292 times since Fri, Nov 9, 2007
CR: Label your X-Axis with more than one identifier
Viewed 2656 times since Tue, Oct 6, 2009
CR: Charting pass-fail data as a p-chart
Viewed 4740 times since Fri, Feb 29, 2008