Home » Categories » CHARTrunner

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 caused by the chart not finding the data in the expected location.

Solution:

You can often solve this problem by using a relative path when telling CHARTrunner where to find the data. For example, if your chart uses data from an Excel spreadsheet with this name:

C:My DocumentsLabData.xls

then in CHARTrunner, set your working folder to C:My Documents.

Next, define your chart. On the data source tab, select the Excel spreadsheet by using the “Browse” button. This will place the full absolute path to the Excel sheet into the form. Edit this path as follows:

Change:
C:My DocumentsLabData.xls

To:
LabData.xls

Now, you can email the chart definition (.crf) and the spreadsheet (.xls) to another CHARTrunner user. As long as they place both of these files in the same folder, they will be able to view the chart without errors sincee the chart definition will be able to find the data.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: Charting pass-fail data as a p-chart
Viewed 4450 times since Fri, Feb 29, 2008
CR: Unable to fully display settings and windows
Viewed 1919 times since Fri, Jan 22, 2010
Cr: Charting elapsed time
Viewed 2450 times since Fri, Nov 9, 2007
CR: Largest Subgroup Size Supported by CHARTrunner
Viewed 2025 times since Fri, Nov 9, 2007
CR: The out-of-control (OOC) test may fail on the last sample with valid data
Viewed 2093 times since Fri, Nov 9, 2007
CR: Show every date on the chart
Viewed 2217 times since Thu, Jan 31, 2008
CR: Error “External table is not in the expected format” using Excel 2007 workbook
Viewed 4036 times since Wed, Oct 14, 2009
CR: Installing CHARTrunner disables desktop wallpaper
Viewed 2059 times since Fri, Nov 9, 2007
CR: Making an X-bar chart with a single data column
Viewed 2076 times since Fri, Nov 9, 2007
CR: CR1.5 - My control chart data lines are not printing
Viewed 2183 times since Fri, Nov 9, 2007