Home » Categories » CHARTrunner

CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula

Revision Date: 2005-09-19

Problem:

You specify in the chart definition to show the data above the grid.  You will see too many decimal places for the data from an Excel column that was calculated by a formula.

Note that formatting the data in Excel to show 2 decimals will not fix the problem since CHARTrunner charts the "raw" number from each cell, not the "rounded to 2 decimal places" number that Excel displays. Note also, that setting the number of decimals on the chart definition form will also not fix the problem as this applies to statistics we compute rather than raw data. However, there IS a solution. In the Excel sheet, use the ROUND function.

Solution:

A formula like this:

=A2/B2

Is changed to this:

=Round(A2/B2,2)

The two means round to 2 decimals.

If you chart this column and ask for the data grid above the chart - it will show two decimals.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: A simple query pattern for summarizing raw data
Viewed 2914 times since Tue, Oct 6, 2009
CR: Unable to fully display settings and windows
Viewed 1919 times since Fri, Jan 22, 2010
CR: Excel tips
Viewed 3020 times since Tue, Oct 6, 2009
CR: Background on out-of-control test rules
Viewed 2298 times since Fri, Nov 9, 2007
CR: Multiple chart lines from one data column
Viewed 2228 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
Cr: Charting elapsed time
Viewed 2450 times since Fri, Nov 9, 2007
CR: Chart [the name of the chart] failed with one or more errors
Viewed 2067 times since Fri, Nov 9, 2007
CR: Charting pass-fail data as a p-chart
Viewed 4450 times since Fri, Feb 29, 2008
CR: Installing CHARTrunner disables desktop wallpaper
Viewed 2059 times since Fri, Nov 9, 2007