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: Multiple chart lines from one data column
Viewed 2290 times since Fri, Nov 9, 2007
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2140 times since Fri, Nov 9, 2007
CR: Background on out-of-control test rules
Viewed 2325 times since Fri, Nov 9, 2007
CR: Collating sequence not supported
Viewed 2693 times since Tue, Dec 11, 2007
CR: General Filtering Tips
Viewed 2231 times since Fri, Nov 9, 2007
CR: Installing CHARTrunner disables desktop wallpaper
Viewed 2099 times since Fri, Nov 9, 2007
CR: Time Display
Viewed 2107 times since Fri, Nov 9, 2007
CR: Label your X-Axis with more than one identifier
Viewed 2565 times since Tue, Oct 6, 2009
CR: Making an X-bar chart with a single data column
Viewed 2110 times since Fri, Nov 9, 2007
CR: Histogram bars beyond specification lines
Viewed 2351 times since Fri, Nov 9, 2007