Home » Categories » CHARTrunner

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 title in the first row to alleviate this behavior.

Ref # 635

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: CHARTrunner and Open Office
Viewed 2386 times since Fri, Nov 9, 2007
CR: The out-of-control (OOC) test may fail on the last sample with valid data
Viewed 2092 times since Fri, Nov 9, 2007
CR: Making a chart transportable
Viewed 2115 times since Fri, Nov 9, 2007
CR: Data grouping tardiness
Viewed 3160 times since Tue, Oct 6, 2009
CR: Error “External table is not in the expected format” using Excel 2007 workbook
Viewed 4035 times since Wed, Oct 14, 2009
CR: Label your X-Axis with more than one identifier
Viewed 2521 times since Tue, Oct 6, 2009
CR: Formatting an Excel Date
Viewed 2449 times since Fri, Nov 9, 2007
CR: Excel tips
Viewed 3019 times since Tue, Oct 6, 2009
CR: CHARTrunner and SharePoint
Viewed 3970 times since Fri, Mar 9, 2012
CR: CR1.1 - Notes and Causes Problem
Viewed 2087 times since Fri, Nov 9, 2007