|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 16th, 2006, 12:42 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Strange Value in my chart data table
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. 
|
|
#2
February 16th, 2006, 01:08 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Strange Value in my chart data table
"owl37" wrote: 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.
|
|
#3
February 16th, 2006, 02:06 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Strange Value in my chart data table
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
| strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
| changing proportion of chart and data table | Dawn Parks | Charts and Charting | 3 | January 6th, 2005 01:18 AM |
| Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
| Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Linear Mode
