Right-click the category axis labels you want to format, and click Font. To change the format of text in category axis labels: Change the format of text and numbers in labels In the Axis label range box, enter the labels you want to use, separated by commas.įor example, type Quarter 1 ,Quarter 2,Quarter 3,Quarter 4. In the Horizontal (Category) Axis Labels box, click Edit. Right-click the category labels you want to change, and click Select Data. To keep the text in the source data on the worksheet the way it is, and just create custom labels, you can enter new label text that's independent of the worksheet data:

Type the text you want in each cell, and press Enter.Īs you change the text in the cells, the labels in the chart are updated. Your chart uses text from its source data for these axis labels.ĭon't confuse the horizontal axis labels-Qtr 1, Qtr 2, Qtr 3, and Qtr 4, as shown below, with the legend labels below them-East Asia Sales 2009 and East Asia Sales 2010.Ĭlick each cell in the worksheet that contains the label text you want to change. Allows you to adjust histogram bin intervals and the approximate number of bars.In a chart you create, axis labels are shown below the horizontal (category, or 'X') axis, next to the vertical (value, or 'Y') axis, and next to the depth axis (in a 3-D chart).

Allows you to experiment with how spec limits impact Cp Cpk by changing them in the histogram calculations worksheet.

Calculations can be viewed and updated in the Excel worksheet created by QI Macros.

Calculates more than 20 process capability analysis metrics including Cp Cpk and Pp Ppk.

What is Cool about QI Macros Histogram Maker in Excel? These are numeric values that tell you how well your process is meeting customer requirements. The best histogram maker's will also calculate process capability metrics Cp, Cpk and Pp Ppk. Data points outside of the spec limits represent products or processes that don't meet customer requirements. There can be both an upper spec limit (USL) and a lower spec limit (LSL) or just one of the two. Does your data fit or not? Is it centered?Ĭustomer Requirements are the Specification Limits (Goal Posts)Įxperts refer to these goal posts as specification limits. They are most valuable when they display your customer's requirements as goal posts. Histograms show the spread, or dispersion, of variable data.

QI Macros will do the math and draw the graph for you.

Select Histograms & Capability from QI Macros menu.

Free Agile Lean Six Sigma Trainer Training.

Animated Lean Six Sigma Video Tutorials.

Statistical Analysis - Hypothesis Testing.

Excel histogram