Issue:
The precision indicated in my Chart axis is not as precise as the numbers from my Table. I have typed in 4 columns of numbers. For example:
Label 1 Label 2 Label 3 Label 4
-------------------------------------------
0.036 0.035 0.038 0.038
0.037 0.039 0.039 0.034
The chart I created from this table has a Y axis that looks like the picture below (Figure 1). Why are my numbers all 0.04?
Answer:
You need to format your cells so that the precision is greater. Select all the numbers in the Table and then choose Number Format from the Table or Chart menu. Change the Number Format to Fixed and the Precision to whatever you need (in this case, 3).
The precision indicated in my Chart axis is not as precise as the numbers from my Table. I have typed in 4 columns of numbers. For example:
Label 1 Label 2 Label 3 Label 4
-------------------------------------------
0.036 0.035 0.038 0.038
0.037 0.039 0.039 0.034
The chart I created from this table has a Y axis that looks like the picture below (Figure 1). Why are my numbers all 0.04?
Answer:
You need to format your cells so that the precision is greater. Select all the numbers in the Table and then choose Number Format from the Table or Chart menu. Change the Number Format to Fixed and the Precision to whatever you need (in this case, 3).
Figure 1