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: Charting counted incidents
Viewed 2190 times since Thu, Feb 23, 2012
Cr: Charting elapsed time
Viewed 2558 times since Fri, Nov 9, 2007
CR: Background on out-of-control test rules
Viewed 2384 times since Fri, Nov 9, 2007
CR: Formatting an Excel Date
Viewed 2625 times since Fri, Nov 9, 2007
CR: Making an X-bar chart with a single data column
Viewed 2160 times since Fri, Nov 9, 2007
CR: Charts with large amounts of data
Viewed 2021 times since Fri, Nov 9, 2007
CR: Making a chart transportable
Viewed 2198 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
CR: General Filtering Tips
Viewed 2292 times since Fri, Nov 9, 2007
CR: CR1.1 - Notes and Causes Problem
Viewed 2166 times since Fri, Nov 9, 2007