Strange Value in my chart data table

[owl37]

Hello,
I have created a chart with 3 different data ranges.
One of the data ranges takes data that has been manually entered. They are
quite long figures i.e. 18288388.31.
In the corresponding entry on the data table I am getting these values:
5e+06.
Anybody know what this means?
Thanks.

 

[Chartsmalm]

Hello,
I have created a chart with 3 different data ranges.
One of the data ranges takes data that has been manually entered. They are
quite long figures i.e. 18288388.31.
In the corresponding entry on the data table I am getting these values:
5e+06.
Anybody know what this means?
Thanks.

What you are seeing is the logrithmic(sp?) expression of your long number,
You need to set the format to allow for this long number. How do you do
that? I don't know. See my post today about formatting the Data Table. You
might watch my post for an answer to my question. You will probably be able
to fix yours with the same info.

 

[Tushar Mehta]

Excel's data table capability is rather limited. You may want to simulate
the effect with something along the lines of
Custom Chart Table
http://www.tushar-mehta.com/excel/newsgroups/data_table/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions