Excel 2007 Line Graph, Data Table, Number Formatting

[Paul]

I'm using Excel 2007, and have created a Line Graph with a Data Table below
the graph. The issue is that the Number Formatting is fine with numbers like
2.53 and 2.58, but the number formatting shows the number of 2.50 as 2.5. It
cuts off the trailing zero for this and only this number in the table. The
source data says "2.50", and all other numbers show two digits to the right
of the decimal point. I've tried a few things, but to no resolution. How
can I fix this so my data table give two digits to the right of all numbers?

 

[Bernard Liengme]

Hi Paul,
I cannot reproduce this in XL 2007.
Tell us what is in the cell with value 2.5. Is it a number or a formula?
You may wish to send me the file ( not to the newsgroup but to my private
email address - remove TRUENORTH)
best wishes
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

 

[Paul]

I just emailed that to you. This problem seems to be occurring with any
trailing zeros. Again, thanks for you assistance with this.

 

[Bernard Liengme]

It has not arrived. Try sending to
(e-mail address removed)
use bliengme in place of bl
(We have to do this to prevent spam!)
best wishes

 

[ShaneDevenshire]

Hi,

Make sure all the cells in the data area are formatted to Number, 2
decimals. However, the display in the Data table is very unfriendly, you
might format the data range to 3 decimals and if there isn't room the data
table will cut off part of the numbers. One thing you can do is change the
font size, second you can resize the plot area or chart to be horizontally
larger. But the best solution is to put the values you want in the
spreadsheet below the chart and there you can control the format anyway you
want. In other words get rid of the data table.

 

[Bernard Liengme]

Answer sent by private mail