CR: Unable to fully display settings and windows
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 on the right side of the monitor or entering ...
- CR: Error “External table is not in the expected format” using Excel 2007 workbook
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 order to read data from files in Microsoft Office ...
- CR: Label your X-Axis with more than one identifier
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? He also wanted the Batch number as part of th ...
- CR: Data grouping tardiness
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 Incidents Date EmpID MinsLate 6/3/2009 4 15 6/2 ...
- CR: A simple query pattern for summarizing raw data
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 customer has a data set containing what I̵ ...
- CR: Excel tips
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 CHARTrunner product. Modern spreadsheets, like Mi ...
- CR: Charting pass-fail data as a p-chart
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 Etc Your data may contain many other columns. For thi ...
- CR: Show every date on the chart
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.4 01/02/02 Product B Sally 11.8 01/04/02 Product A Tom 11.6 01/10/02 Product C Susan 12 ...
- CR: Collating sequence not supported
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 occur when the Excel sheet contains a date column ...
- CR: Where to find MDAC components
Revision Date: 2005-09-19 If you did not install the MDAC components and need them, they are available on the Quality Suite CD and online at http://www.chartrunner.com/mdac.htm. Run the file, mdac_typ.exe, to install the MDAC components. Information about the various versions of MDAC can be ...
- CR: Some Excel Spreadsheet Values Seem To Be Missing
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 default the Jet 4.0 database engine, which is used to r ...
- CR: Why is my first row of data not included when I get my chart from Excel
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 included. Solution: Simply insert a titl ...
- CR: Making an X-bar chart with a single data column
Revision Date: 2005-09-19 Problem: Several customers have presented us with data in the following general form: Date Number of days 8/1/2003 12 8/1/2003 11 8/1/2003 9 8/2/2003 8 8/2/2003 10 8/3/2003 11 8/3/2003 ...
- CR: Time Display
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 Control Panel. Select Regional Settings Click on ...
- CR: SQL Server Stored Procedures Returns No Records
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 may be returned depending upon the version of CHARTru ...
- CR: The out-of-control (OOC) test may fail on the last sample with valid data
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 data falls outside the control limit, it is not flagged as o ...
- CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
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 data in Excel to show 2 decimals will not fix the proble ...
- CR: Multiple chart lines from one data column
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/2003 Admission 4 1/1/2003 Waiting 5 1/3/2003 Admission 3 1/3/2 ...
- CR: A custom query for Length of Stay data
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. Imagine that you have data like this covering an entire year ...
- CR: CR1.1 - Charts in the Chart Workspace do not print all of the charts
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
CR Data Source (22)
