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: Charting counted incidents
Viewed 2031 times since Thu, Feb 23, 2012
CR: Data grouping tardiness
Viewed 3247 times since Tue, Oct 6, 2009
CR: Making a chart transportable
Viewed 2148 times since Fri, Nov 9, 2007
CR: Chart [the name of the chart] failed with one or more errors
Viewed 2107 times since Fri, Nov 9, 2007
CR: CHARTrunner and SharePoint
Viewed 4046 times since Fri, Mar 9, 2012
CR: Some Excel Spreadsheet Values Seem To Be Missing
Viewed 2241 times since Fri, Nov 9, 2007
CR: SQL Server Stored Procedures Returns No Records
Viewed 2298 times since Fri, Nov 9, 2007
CR: A custom query for Length of Stay data
Viewed 2581 times since Fri, Nov 9, 2007
CR: CR1.5 - My control chart data lines are not printing
Viewed 2208 times since Fri, Nov 9, 2007
CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
Viewed 3759 times since Fri, Nov 9, 2007