Consider the chart in exhibit 1, below, which compares soaring Sales (the blue line) with ebbing Operating income (the pink line).
Click on Insert on the toolbar, then Chart to bring up the Chart Wizard (exhibit 3, below).
Median/Individual charting reportedly solves this dilemma by combining the median and individual control charts.
The package consists of a configuration kit that provides the necessary tools to set up data collection, design data input screens, and produce charts.
Depending on the appearance of these charts, you will be able to tell whether your process is in control or out of control.
However, if there are a few high-running jobs, you would want to prepare similar charts for each of them.
Chart 10: PREPAID/WHOLESALE SUBSCRIBERS BY OPERATOR
Chart 11: PREPAID/WHOLESALE SUBSCRIBER GROWTH BY OPERATOR
THIS ARTICLE PROVIDES four tools--the horizontal bar graph, the Gantt chart, the thermometer chart and the bubble graph--that can be added to spreadsheets by formatting the data in the right way and by writing a few formulas.
To create this chart, enter the data shown in columns A through D; then enter the following formulas:
All formulas given in Table 1 apply to the X and moving range charts using the constants for a sample size of one (n = 1).
Actually, these charts have been used for situations ranging from multiple readings per shift to one reading per week.
Chart 21: MONTHLY ARPU GROWTH BY OPERATOR (YoY %) --
Chart 87: GROSS ADDITIONS GROWTH BY OPERATOR (YoY) -
113: CAPEX BY OPERATOR (REPORTING CURRENCY) --