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: Charts with large amounts of data
Viewed 1870 times since Fri, Nov 9, 2007
CR: Making a chart transportable
Viewed 2072 times since Fri, Nov 9, 2007
CR: Some Excel Spreadsheet Values Seem To Be Missing
Viewed 2174 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: Charts not working on a new PC
Viewed 1955 times since Fri, Nov 9, 2007
CR: Chart [the name of the chart] failed with one or more errors
Viewed 2032 times since Fri, Nov 9, 2007
CR: Histogram bars beyond specification lines
Viewed 2267 times since Fri, Nov 9, 2007
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2064 times since Fri, Nov 9, 2007
Cr: Charting elapsed time
Viewed 2399 times since Fri, Nov 9, 2007
CR: Why is my first row of data not included when I get my chart from Excel
Viewed 2076 times since Fri, Nov 9, 2007