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: CR1.1 - Charts in the Chart Workspace do not print all of the charts
Viewed 2127 times since Fri, Nov 9, 2007
CR: A custom query for Length of Stay data
Viewed 2656 times since Fri, Nov 9, 2007
CR: CR1.5 - My control chart data lines are not printing
Viewed 2262 times since Fri, Nov 9, 2007
CR: Excel tips
Viewed 3124 times since Tue, Oct 6, 2009
CR: Formatting an Excel Date
Viewed 2625 times since Fri, Nov 9, 2007
CR: Charting counted incidents
Viewed 2190 times since Thu, Feb 23, 2012
CR: Multiple chart lines from one data column
Viewed 2357 times since Fri, Nov 9, 2007
CR: Charting pass-fail data as a p-chart
Viewed 4739 times since Fri, Feb 29, 2008
Cr: Charting elapsed time
Viewed 2558 times since Fri, Nov 9, 2007
CR: Chart [the name of the chart] failed with one or more errors
Viewed 2174 times since Fri, Nov 9, 2007