Control Charts of Date and Time Data
How to Create Charts Using Time and Date Formatted Data
Recently, I was at the ASQ Six Sigma conference and one attendee was bemoaning the fact that he couldn't create a control chart using "time format" data in his existing SPC software. He was surprised when I showed him how easy it can be done in QI Macros for Excel
Control Charting Time
When collecting performance metrics, he was using time in Excel format (hh:mm:ss). QI Macros can easily turn this data into a control chart or histogram. Start by selecting the data, just like any other data, and then choosing the chart you want from the QI Macros menu.
For example, using the above data an XMR chart would look like this:
Histograms of Time
Use the same approach to create a histogram. Select the data and choose "Histogram with Cp and Cpk". When working with time data, there is usually an upper specification limit (USL) to do a task, but not a lower specification limit. To create a histogram with only an USL, click "Cancel" on the LSL prompt.
Control charts and histograms of time are easy using QI Macros. Try it and see.
Learn More
- Watch video of creating a control chart in Excel using QI Macros
- Control Chart Types
- Control Chart Stability Rules
Why Choose QI Macros Over Other Control Chart Software?
Affordable
- Only $279 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
