Merged cells are particularly hard to use when copying, pasting or charting data. You can't tell if the title is in the first or second column. Instead, right click on the cell and use Format-Cells - "Wrap Text" to fit the text into the cell:ĭon't merge cells like " Circuit Board Defects" below. The most common and troubling mistakes are: If your data has a numerator and denominator, put them in adjacent columns with a leading heading (e.g., discrepancies/sample size): If the data is a category like type of defect, then use descriptive labels for each category instead of codes (e.g., FF for folded flaps or BF for Bent/Damaged Flaps):Īs shown in this example, use color for visual clarity. That way QI Macros cannot be confused whether it's data or a label.) (If this is a number like 1,2,3 consider using an apostrophe in front of the number to force it to be text. Row Headings: If the data is organized by time, then the row headings should be: Every column and row should have a heading:Ĭolumn Heading: QI Macros will attempt to use whatever is in the column heading for chart tiles, so make the title descriptive. Having settled on vertical, it's time to think about headings. Given a choice, start with vertical data. You are limited to 255 columns horizontally: Why? Because there's a lot more rows than columns available. QI Macros will draw the chart either way, but the best way is vertically. Since most calendars show time horizontally, not vertically, most people tend to show data organized by dates and times horizontally. People sometimes make their data hard to chart or analyze by setting it up incorrectly. QI Macros Tips » Organize Data in Excel How to Organize Data in Excel
Free Agile Lean Six Sigma Trainer Training.Animated Lean Six Sigma Video Tutorials.
0 kommentar(er)
