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
|
|||
|
|||
Zero's plotted in charts?
Why would I show zero's for a column of data in my chart that are actually
very large(56869685). Some of my charts have date segments that are missing when the data is there in the table? I checked the formatting for the data in the table and it is all set to a number, no decimal format. I don't understand? -- Thank you! |
#2
|
|||
|
|||
Zero's plotted in charts?
The numbers may have been entered as text, even if the cells are now
formatted as numbers. You can tell by clicking the Add Decimal button. If no decimal digit is added, it's text. To fix, select the column of data, and use Text to Columns with settings that won't split any of the cells into more than one column. This function converts text into numbers. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 5/27/2010 4:52 PM, Doug wrote: Why would I show zero's for a column of data in my chart that are actually very large(56869685). Some of my charts have date segments that are missing when the data is there in the table? I checked the formatting for the data in the table and it is all set to a number, no decimal format. I don't understand? |
Thread Tools | |
Display Modes | |
|
|