Category Articles RSS Feed
CR: Charting pass-fail data as a p-chart
Viewed 4243 times since Fri, Feb 29, 2008
Revision Date: 2005-09-19 Problem: Several customers have asked questions about making a p-chart from data in this general form: SerialNumber Date PassFail 1001 1/1/2003 PASS 1002 1/1/2003 PASS 1003 1/2/2003 PASS 1004 1/2/2003 FAIL ... Read More
CR: Error “External table is not in the expected format” using Excel 2007 workbook
Viewed 3844 times since Wed, Oct 14, 2009
Problem: When CHARTrunner attempts to read from an Excel 2007 XLSX workbook file, an error message that contains the words “External table is not in the expected format” is encountered. CHARTrunner must use the ACE database engine in... Read More
CR: CHARTrunner and SharePoint
Viewed 3803 times since Fri, Mar 9, 2012
Revision Date: 2012-03-09 Sometimes PQ is asked if CHARTrunner and SharePoint work well together. Here are some ways that CHARTrunner and SharePoint can be used together. You can store file based data sources like Excel workbooks and Access... Read More
CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
Viewed 3463 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: You specify in the chart definition to show the data above the grid.  You will see too many decimal places for the data from an Excel column that was calculated by a formula. Note that formatting the... Read More
CR: Data grouping tardiness
Viewed 3026 times since Tue, Oct 6, 2009
Some CHARTrunner customers express the need to count or group data that has been accumulated during certain periods of time. Let’s pretend today is September 25, 2009 and consider the following tardiness data. Employee Tardiness... Read More
CR: Excel tips
Viewed 2883 times since Tue, Oct 6, 2009
At PQ, we often see spreadsheets our customers have created. This happens in the course of a support call while we are helping with an SPC question, a data analysis question, or when we are providing guidance on customizing an SPC chart from our... Read More
CR: A simple query pattern for summarizing raw data
Viewed 2781 times since Tue, Oct 6, 2009
CHARTrunner customers like to visualize piles of data in chart form. Something about a neat line going across the page is easier to consume than rows and columns of numbers. Recently, we’ve had several calls that follow a similar pattern. The... Read More
CR: Collating sequence not supported
Viewed 2502 times since Tue, Dec 11, 2007
Revision Date: 2005-09-19 Problem: When charting Excel data that may have originated by exporting from a Paradox database, the following error is displayed:Selected collating sequence not supported by the operating system Solution: This may... Read More
CR: Label your X-Axis with more than one identifier
Viewed 2409 times since Tue, Oct 6, 2009
Revision Date: 2009-01-29 Problem: I spoke with a customer the other day who wanted multiple labels along the x-axis of his control chart. His data set and original chart looked like this: Notice how the x-axis labels contain ONLY the date column?... Read More
CR: A custom query for Length of Stay data
Viewed 2370 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 This article applies to CHARTrunner versions 1.6 and above. Many customers have Excel data in a form similar to this: DischargeDate LOS 1/1/2003 3 1/2/2003 2 1/3/2003 4 1/4/2003 2 1/5/2003 1 etc.  ... Read More
Cr: Charting elapsed time
Viewed 2350 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Many users create columns in Excel to calculate the difference between two times. Usually a begin time and an end time are used to create an elapsed time, which will become the data for a chart. Depending on... Read More
CR: Formatting an Excel Date
Viewed 2305 times since Fri, Nov 9, 2007
Revision Date: 2006-12-13 Problem: In Microsoft Excel, you might have a date column where you have formatted the dates so they look like this: Jan-03Feb-03Mar-03 However, when you use this date column as an identifier within CHARTrunner,... Read More
CR: CHARTrunner and Open Office
Viewed 2288 times since Fri, Nov 9, 2007
Revision Date: 2006-03-01 Problem: Can CHARTrunner be used with Open Office? Solution: Open Office is "free" software that positions itself as a replacment for Microsoft Office. Open Office can be dowloaded from: http://about.openoffice.org/index... Read More
CR: Background on out-of-control test rules
Viewed 2211 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 This article applies to CHARTrunner versions 1.7 and above.CHARTrunner does out-of-control testing on all control charts. This testing is based upon rules called out-of-control test rules. These rules are stored in special... Read More
CR: Histogram bars beyond specification lines
Viewed 2208 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Occasionally, SQCpack and CHARTrunner will show histogram bars beyond the specification lines. This may happen despite the fact that a careful review of the data shows no values beyond the specifications. How can... Read More
CR: SQL Server Stored Procedures Returns No Records
Viewed 2171 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: In some cases when using a SQL Server stored procedure to fetch data for a chart no data is returned and an error message is displayed, or the program appears to “hang”. Several different error messages... Read More
CR: Show every date on the chart
Viewed 2134 times since Thu, Jan 31, 2008
Revision Date: 2005-09-19 Problem: Our technical support team often receives questions relating to the following data management issue.Imagine that you collect data in this form: 01/01/02 Product A Bob 12.401/02/02 Product B Sally 11.801/04/02... Read More
CR: Some Excel Spreadsheet Values Seem To Be Missing
Viewed 2120 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: When CHARTrunner fetches a column of data from an Excel spreadsheet and the column contains both numeric and non-numeric data then in some cases not all of the data will appear on the chart. Cause: By... Read More
CR: General Filtering Tips
Viewed 2117 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Information: Use the Filter function to pinpoint the data you are interested in analyzing. CHARTrunner provides a number of options for defining filters. If a data definition includes a filter, "Filter is defined"... Read More
CR: Multiple chart lines from one data column
Viewed 2105 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: You may have a need to look at a single data column and create a chart with more than one data line. Imagine a spreadsheet containing many rows in this general form:  Date Section Rating 1/1... Read More
CR: CR1.5 - My control chart data lines are not printing
Viewed 2102 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Control chart data lines are not printing Solution: Use the Windows Explorer and find the "Default control chart style.cst" file. The default location for this file is "C:Program FilesPQ... Read More
CR: Grouping counts by date in Excel
Viewed 2060 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Several customers have asked about counting by date. Imagine that you are collecting data where each row contains a date along with other information. You want to create a chart showing how many records you have for... Read More
CR: Why is my first row of data not included when I get my chart from Excel
Viewed 2028 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: When linking to Excel, if the spreadsheet starts with the data, i.e. no header or column title, CHARTrunner uses the first row as a header. Thus the chart will have n-1 samples in it. Therefore, the first row is not... Read More
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2021 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Changing the chart type changes the Default Chart Style to missing. The first indication is that the colors are all black & white. Solution: Exit CHARTrunner. Then, rename or delete the .CST... Read More
CR: The out-of-control (OOC) test may fail on the last sample with valid data
Viewed 2008 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: The out-of-control (OOC) test may fail  on the last sample with valid data. When the last xx samples are selected and the last sample in the range has an ID, but no data, and the last sample with... Read More
CR: Making a chart transportable
Viewed 2006 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: A chart that works fine on your workstation may generate errors if you send it to another CHARTrunner user for review on a different workstation. This can be caused by the chart not finding the data in the expected... Read More
CR: CR1.1 - Notes and Causes Problem
Viewed 1998 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: When creating a chart, and one of the columns is determined as a note, and then on the chart definition you say to display "causes" it displays the notes. Solution: Upgrade tp 1.1.170 or above. http://www... Read More
CR: Time Display
Viewed 1986 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 CHARTrunner displays time on charts based on the computer's regional settings, either as AM / PM or military (24-hour clock). To change the time display: Open the Windows Start Menu and select Settings. Select... Read More
CR: Chart [the name of the chart] failed with one or more errors
Viewed 1980 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: When a column name starts with one or more spaces, the following error appears:Chart [the name of the chart] failed with one or more errors:[PQCrDef.Display] Failed to Prepare Chart  [the name of the chart]... Read More
CR: Making an X-bar chart with a single data column
Viewed 1969 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Several customers have presented us with data in the following general form: Date                 Number of days8/1/2003 ... Read More
CR: Installing CHARTrunner disables desktop wallpaper
Viewed 1953 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: When installing CHARTrunner on some computers the desktop wallpaper may be disabled. Solution: This is a known side-effect of installing MDAC 2.5. (See Microsoft's technical note regarding this problem at... Read More
CR: CR1.1 - Charts in the Chart Workspace do not print all of the charts
Viewed 1952 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Charts in the Chart Workspace do not print all of the charts. Solution: Charts will print individually. This is fixed in 1.1.166 and above. Ref # 772 Read More
CR: Largest Subgroup Size Supported by CHARTrunner
Viewed 1922 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: What is the largest subgroup size supported by CHARTrunner? Solution: When you define an X-bar chart, on the data definition tab, you may map up to 40 measurement columns. This will result in a chart where each data... Read More
CR: Charts not working on a new PC
Viewed 1902 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Problem: Customers have reported that after installing CHARTrunner on a new PC, charts that used to work begin producing errors. One error message contained the following text:        ... Read More
CR: Bar Chart of a column of numbers in various categories
Viewed 1857 times since Fri, Nov 9, 2007
Revision Date: 2007-03-29 Problem: You have a large column of numeric values in an Excel spreadsheet. You would like to see a bar chart showing how many numbers fall into some predefined categories. For example, your numbers might look like this: ... Read More
CR: Charts with large amounts of data
Viewed 1815 times since Fri, Nov 9, 2007
Revision Date: 2005-09-19 Information: If you define a CHARTrunner chart that will ultimately include a large amount of data, the performance can be improved by minimizing the number of columns that you "map" on the data definition tab. In... Read More
CR: Unable to fully display settings and windows
Viewed 1783 times since Fri, Jan 22, 2010
Revision Date: 2010-01-22Problem: CHARTrunner may not be able to display a full window on the screen. This can hinder the user’s ability to create and view charts. This is most noticeable when attempting to select from a drop down choice list... Read More
CR: Charting counted incidents
Viewed 1774 times since Thu, Feb 23, 2012
Customers often need to chart Excel data that is the result of a database query. The database might be a customer relationship management system (CRM) or it might be a hospital wide patient management system. In either case a query is performed, the... Read More