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 |
#11
|
|||
|
|||
Time and Date on X axis
My bad. The formula was in C2.
- Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ dvt wrote: Jon Peltier wrote: I put your data into columns A and B, formatted as text to simulate the worst. I put this formula in B2 and filled it down: =A2+B2 DataMan wrote: You put the formula in B2? I'll bet that was a typo on Jon's part. I'm quite sure he meant C2, not B2. Dave dvt at psu dot edu |
#12
|
|||
|
|||
Time and Date on X axis
The program that I use to pull the data from our SCADA system apparently
inserts a space character before the time. When pulling the csv file into Excel it brings this same space character into the time column that precedes every time entry. Remove the space and the addition works. Yea! I will play with this at work Monday and see what I can do to remove the spaces before doing the math. One thought. This space character has never triped up Excel 97 before. I wonder whats up with that? Thanks for all the help. I will let you know how it goes. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#13
|
|||
|
|||
Time and Date on X axis
In Excel 97, the axis labels were set up as text labels, without any
numerical interpretation. The problem is trying to turn text into numerical values, and nonnumeric characters throw off the conversion. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ DataMan wrote: The program that I use to pull the data from our SCADA system apparently inserts a space character before the time. When pulling the csv file into Excel it brings this same space character into the time column that precedes every time entry. Remove the space and the addition works. Yea! I will play with this at work Monday and see what I can do to remove the spaces before doing the math. One thought. This space character has never triped up Excel 97 before. I wonder whats up with that? Thanks for all the help. I will let you know how it goes. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
Thread Tools | |
Display Modes | |
|
|