CR: Simultaneous Use of CHARTrunner and Excel with a Workbook
Revision Date: 2005-11-07
Problem:
Under some circumstances you may experience problems when using Microsoft Excel to open or edit a workbook file at the same time that CHARTrunner is using that s...
- 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 suppor...
- CR: Issues Changing From CHARTrunner-XL 1.7 to 2.0 Excel Add-In
Revision Date: 2005-09-20
Problem:
The CHARTrunner-XL 1.7 Add-In was enabled in Microsoft Excel at some time in
the past. Now CHARTrunner 2.0 is installed and I have run the CHARTrunner-...
- CR: Missing the First Row of Data from an Excel Data Source
Ref # 635
Problem
When linking to Excel, CHARTrunner uses the first row as a header.
If the spreadsheet starts with the data, i.e. no header or column
title, the first row will not be chart...
- CR: When I mark Excel data with a cause - it does not get treated as a cause
Revision Date: 2005-09-01
Problem:
Data marked with a cause does not get treated as a cause.
Solution:
Open database in Microsoft Excel.
Format the column in Micros...
- CR: Grouping counts by date in Excel
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 t...
- CR: Excel Data Source with a Column that Contains Both Numeric and Non-numeric Data
Ref #729
Problem:
An Excel data source has a notes column that contains BOTH numeric
and non-numeric characters. In CHARTrunner, some of this data is
missing. The data is missing from rows ...
- CR: Formatting an Excel Date
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-03 Feb-03 Mar-03
Howev...
- CR: CHARTrunner and Open Office
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 c...
- CR: Minitab as a Data Source
Ref # 636
CHARTrunner can chart data that is stored in Minitab files.
By default, Minitab stores data in Projects .MPJ and Worksheets .MTW
but by using the following steps, you can store dat...
- 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 ca...
- CR: Making a chart transportable
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 cau...
- 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 h...
- GP: How to export data from GAGEpack
Revision Date: 2005-09-02
To save your GAGEpack data in an Excel spreadsheet, you will want to follow these steps:
Open your GAGEpack 2000 database in Microsoft Access 97. ...
- 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 colu...
- CR: Excel Data Source Requirements
CHARTrunner allows you to create charts using data from a variety of
sources. However, CHARTrunner thinks about data with a database
metaphor. In a database, a table contains many rows (or records)...
- CR: Why are my charts being displayed with many decimal places
Revision Date: 2005-09-01
Problem:
Charts are being displayed with many decimal places.
Solution:
Open the CHARTrunner file in Microsoft Excel.
Change current form...
- 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...
- SP: Changing the width and height of an image does not affect its size when pasted into Excel or Word
Revision Date: 2005-09-07
Problem:
Changing the width and height of an image does not affect its size when pasted into Excel or Word.
Solution:
From the data entry scre...
- CR: Chart refresh is not refreshing when data is added
Ref # 644
Problem:
When I press F5 to refresh my displayed chart, or if the chart refreshes automatically every N seconds, the "refreshed" chart doesn't show any newly added data.
Solution:
M...