|
|
#1
01-21-2012, 01:36 PM
|
|||
|
|||
how to display Timestamp on x-axis in Scatter smooth line graph
hi all..
i,m using excel 2010 on windows XP. i want to display timestamp on the x-axis in the format hh:mm:ss i.e from 17:18:48 hour till 23:59:56 hour instead of just integer i.e 0 to 5000. i have attached my excel file for reference. any help would be much appreciated. 
|
|
#2
01-23-2012, 02:28 AM
|
||||
|
||||
|
Hi
your time values in col B are text looking like time, not real times. To solve, in an unused column, insert =timevalue(B5) and drag down to the end of the range. Copy then Paste Special Values over col B - Format as needed Then rebuild your graph
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
| Tags |
| scatter plot, timestamp, x-axis |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Line Graph Overlay | mgonda | Office | 0 | 11-14-2011 05:53 PM |
| Triple Axis Line Graph | sschultz0956 | Excel | 1 | 09-28-2010 12:39 PM |
| how do I add data values in Col A into X axis on bar graph? | hazz | Excel | 1 | 04-27-2010 01:42 PM |
 Target line on a excel graph
|
leroytrolley | Excel | 1 | 01-16-2009 04:19 PM |
|
Timestamp for notes in contacts?
|
boe | Outlook | 2 | 11-30-2005 04:19 PM |
Windows XP 
Office 2010 32bit
Linear Mode
