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.

--
Thanks,
Shane Devenshire


"Paul" wrote:

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?