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/ne...able/index.htm

--
Regards,

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

In article , owl37
@discussions.microsoft.com says...
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.