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: Data grouping tardiness
Viewed 3098 times since Tue, Oct 6, 2009
CR: Charts with large amounts of data
Viewed 1870 times since Fri, Nov 9, 2007
CR: Chart [the name of the chart] failed with one or more errors
Viewed 2033 times since Fri, Nov 9, 2007
CR: CR1.1 - Notes and Causes Problem
Viewed 2050 times since Fri, Nov 9, 2007
CR: Label your X-Axis with more than one identifier
Viewed 2471 times since Tue, Oct 6, 2009
CR: Making an X-bar chart with a single data column
Viewed 2029 times since Fri, Nov 9, 2007
CR: CR1.5 - My control chart data lines are not printing
Viewed 2152 times since Fri, Nov 9, 2007
CR: CHARTrunner and SharePoint
Viewed 3899 times since Fri, Mar 9, 2012
CR: Charts not working on a new PC
Viewed 1955 times since Fri, Nov 9, 2007
CR: The out-of-control (OOC) test may fail on the last sample with valid data
Viewed 2057 times since Fri, Nov 9, 2007