Excel 2007 Line Graph, Data Table, Number Formatting
 

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?

Excel 2007 Line Graph, Data Table, Number Formatting
 

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" wrote in message
...
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?

Excel 2007 Line Graph, Data Table, Number Formatting
 

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" wrote:

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" wrote in message
...
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?

Excel 2007 Line Graph, Data Table, Number Formatting
 

It has not arrived. Try sending to

use bliengme in place of bl
(We have to do this to prevent spam!)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Paul" wrote in message
...
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" wrote:

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" wrote in message
...
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?

Excel 2007 Line Graph, Data Table, Number Formatting
 

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?

Excel 2007 Line Graph, Data Table, Number Formatting
 

Answer sent by private mail
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
It has not arrived. Try sending to

use bliengme in place of bl
(We have to do this to prevent spam!)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Paul" wrote in message
...
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" wrote:

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" wrote in message
...
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?