i have 2 instruments that set in different time interval sampling
they observe one periodic phenomena in a month i want to compare their result in one picture (chart line) how can i do it
10:10 2.54
10:20 2.70
10:30 2.895
..............
............
compare with below
10:12 2.60
10:14 2.65
10:17 2.68
.............
...........
What chart type are you using and what chart type do you need to use? My first thought is to use an XY scatter plot (not line). XY scatter easily uses a different "X Values" range for each data series and places them correctly along the X axis.
Originally Posted by shg
hi
i need line chart
What does a line chart offer that an XY scatter does not that suggests to you that you require a line and not an XY scatter? If I understand your requirements, this should be very easy with a scatter chart, but will be somewhat difficult with a line chart, so I want to be sure I understand your requirements.
If there is a chance you are uncertain of the similarities between XY scatter and line chart types, I would recommend this page http://peltiertech.com/Excel/ChartsH...ValueAxis.html and http://peltiertech.com/line-charts-vs-xy-charts/
hi
I know that i can show two line in scatter line but what can i do with the date change AS BELOW
when the date change all the next hour heights are shown in previous 24th hour of the day before
and i want to show continues line
thanks
time height time2 height2
1/14/2016 14:30 1.156 14/1/2016 14:30 1.105
1/14/2016 14:32 1.166 14/1/2016 14:45 1.152
1/14/2016 14:34 1.206 14/1/2016 15:00 1.232
1/14/2016 14:36 1.176 14/1/2016 15:15 1.292
1/14/2016 14:38 1.176 14/1/2016 15:30 1.372
1/14/2016 14:42 1.076 14/1/2016 15:45 1.448
1/14/2016 14:50 1.086 14/1/2016 16:00 1.523
1/14/2016 14:50 1.086 14/1/2016 16:15 1.603
1/14/2016 14:50 1.086 14/1/2016 16:30 1.708
1/14/2016 14:50 1.086 14/1/2016 16:45 1.819
1/14/2016 14:50 1.086 14/1/2016 17:00 1.893
1/14/2016 14:52 1.096 14/1/2016 17:15 1.964
1/14/2016 14:54 1.106 14/1/2016 17:30 2.087
1/14/2016 14:56 1.106 14/1/2016 17:45 2.123
1/14/2016 14:58 1.096 14/1/2016 18:00 2.152
1/14/2016 15:00 1.056 14/1/2016 18:15 2.21
1/14/2016 15:04 1.166 14/1/2016 18:30 2.258
1/14/2016 15:06 1.146 14/1/2016 18:45 2.296
1/14/2016 15:08 1.166 14/1/2016 19:00 2.327
1/14/2016 15:10 1.166 14/1/2016 19:15 2.344
1/14/2016 15:15 1.316 14/1/2016 19:30 2.344
1/14/2016 15:20 1.336 14/1/2016 19:45 2.339
1/14/2016 15:25 1.366 14/1/2016 20:00 2.313
1/14/2016 15:30 1.436 14/1/2016 20:15 2.283
1/14/2016 15:35 1.336 14/1/2016 20:30 2.242
1/14/2016 15:40 1.436 14/1/2016 20:45 2.186
1/14/2016 15:45 1.456 14/1/2016 21:00 2.114
1/14/2016 15:50 1.476 14/1/2016 21:15 2.045
1/14/2016 15:55 1.526 14/1/2016 21:30 1.957
1/14/2016 16:00 1.536 14/1/2016 21:45 1.871
1/14/2016 16:05 1.566 14/1/2016 22:00 1.761
1/14/2016 16:10 1.606 14/1/2016 22:15 1.695
1/14/2016 16:15 1.626 14/1/2016 22:30 1.59
1/14/2016 16:20 1.656 14/1/2016 22:45 1.485
1/14/2016 16:30 1.706 14/1/2016 23:00 1.384
1/14/2016 16:40 1.756 14/1/2016 23:15 1.291
1/14/2016 16:50 1.826 14/1/2016 23:30 1.183
1/14/2016 17:00 1.866 14/1/2016 23:45 1.095
1/14/2016 17:10 1.926 15/1/2016 0:00 0.999
1/14/2016 17:20 1.986 15/1/2016 0:15 0.935
1/14/2016 17:30 2.016 15/1/2016 0:30 0.866
1/14/2016 17:40 2.066 15/1/2016 0:45 0.821
1/14/2016 17:50 2.116 15/1/2016 1:00 0.748
1/14/2016 18:00 2.156 15/1/2016 1:15 0.708
1/14/2016 18:10 2.196 15/1/2016 1:30 0.687
1/14/2016 18:20 2.216 15/1/2016 1:45 0.668
1/14/2016 18:30 2.246 15/1/2016 2:00 0.671
1/14/2016 18:40 2.266 15/1/2016 2:15 0.687
1/14/2016 18:50 2.286 15/1/2016 2:30 0.72
1/14/2016 19:00 2.296 15/1/2016 2:45 0.761
1/14/2016 19:10 2.296 15/1/2016 3:00 0.808
1/14/2016 19:20 2.326 15/1/2016 3:15 0.891
1/14/2016 19:30 2.326 15/1/2016 3:30 0.972
1/14/2016 19:40 2.316 15/1/2016 3:45 1.088
1/14/2016 19:50 2.306 15/1/2016 4:00 1.178
1/14/2016 20:00 2.286 15/1/2016 4:15 1.299
1/14/2016 20:10 2.286 15/1/2016 4:30 1.424
1/14/2016 20:20 2.266 15/1/2016 4:45 1.549
1/14/2016 20:30 2.216 15/1/2016 5:00 1.699
1/14/2016 20:40 2.196 15/1/2016 5:15 1.813
1/14/2016 20:50 2.156 15/1/2016 5:30 1.921
1/14/2016 21:00 2.106 15/1/2016 5:45 2.018
1/14/2016 21:10 2.056 15/1/2016 6:00 2.109
1/14/2016 21:20 2.006 15/1/2016 6:15 2.184
1/14/2016 21:30 1.956 15/1/2016 6:30 2.28
1/14/2016 21:40 1.886 15/1/2016 6:45 2.341
1/14/2016 21:50 1.836 15/1/2016 7:00 2.409
1/14/2016 22:00 1.776 15/1/2016 7:15 2.475
1/14/2016 22:10 1.706 15/1/2016 7:30 2.5
1/14/2016 22:20 1.656 15/1/2016 7:45 2.543
1/14/2016 22:30 1.606 15/1/2016 8:00 2.568
1/14/2016 22:50 1.446 15/1/2016 8:15 2.605
1/14/2016 23:00 1.406 15/1/2016 8:30 2.601
1/14/2016 23:10 1.326 15/1/2016 8:45 2.603
1/14/2016 23:20 1.276 15/1/2016 9:00 2.56
1/14/2016 23:30 1.206 15/1/2016 9:15 2.513
1/14/2016 23:40 1.156 15/1/2016 9:30 2.484
1/14/2016 23:50 1.106 15/1/2016 9:45 2.411
1/15/2016 0:00 1.036 15/1/2016 10:00 2.326
1/15/2016 0:10 0.996 15/1/2016 10:15 2.252
1/15/2016 0:20 0.956 15/1/2016 10:30 2.164
1/15/2016 0:30 0.896 15/1/2016 10:45 2.07
1/15/2016 0:40 0.876 15/1/2016 11:00 1.959
1/15/2016 0:50 0.836 15/1/2016 11:15 1.873
1/15/2016 1:00 0.796 15/1/2016 11:30 1.771
1/15/2016 1:10 0.766 15/1/2016 11:45 1.675
1/15/2016 1:20 0.746 15/1/2016 12:00 1.589
1/15/2016 1:30 0.736 15/1/2016 12:15 1.49
1/15/2016 1:40 0.696 15/1/2016 12:30 1.42
1/15/2016 1:50 0.706 15/1/2016 12:45 1.357
1/15/2016 2:00 0.716 15/1/2016 13:00 1.299
1/15/2016 2:10 0.716 15/1/2016 13:15 1.241
1/15/2016 2:20 0.746 15/1/2016 13:30 1.192
1/15/2016 2:30 0.776 15/1/2016 13:45 1.161
1/15/2016 2:40 0.796 15/1/2016 14:00 1.125
1/15/2016 2:50 0.826 15/1/2016 14:15 1.102
1/15/2016 3:00 0.856 15/1/2016 14:30 1.112
1/15/2016 3:10 0.896 15/1/2016 14:45 1.121
1/15/2016 3:20 0.946 15/1/2016 15:00 1.141
1/15/2016 3:30 1.016 15/1/2016 15:15 1.192
1/15/2016 3:40 1.066 15/1/2016 15:30 1.21
1/15/2016 3:50 1.126 15/1/2016 15:45 1.271
1/15/2016 4:00 1.196 15/1/2016 16:00 1.339
1/15/2016 4:10 1.286 15/1/2016 16:15 1.396
1/15/2016 4:20 1.366 15/1/2016 16:30 1.473
1/15/2016 4:30 1.436 15/1/2016 16:45 1.547
1/15/2016 4:40 1.526 15/1/2016 17:00 1.615
1/15/2016 4:50 1.606 15/1/2016 17:15 1.707
1/15/2016 5:00 1.686 15/1/2016 17:30 1.813
1/15/2016 5:10 1.756 15/1/2016 17:45 1.915
1/15/2016 5:20 1.836 15/1/2016 18:00 1.961
1/15/2016 5:30 1.916 15/1/2016 18:15 2.065
1/15/2016 5:40 1.966 15/1/2016 18:30 2.134
1/15/2016 5:50 2.026 15/1/2016 18:45 2.193
1/15/2016 6:00 2.086 15/1/2016 19:00 2.251
1/15/2016 6:10 2.156 15/1/2016 19:15 2.284
1/15/2016 6:20 2.196 15/1/2016 19:30 2.321
1/15/2016 6:30 2.256 15/1/2016 19:45 2.352
1/15/2016 6:40 2.296 15/1/2016 20:00 2.378
1/15/2016 6:50 2.336 15/1/2016 20:15 2.387
1/15/2016 7:00 2.386 15/1/2016 20:30 2.394
1/15/2016 7:10 2.426 15/1/2016 20:45 2.379
1/15/2016 7:20 2.446 15/1/2016 21:00 2.344
1/15/2016 7:30 2.476 15/1/2016 21:15 2.312
1/15/2016 7:40 2.516 15/1/2016 21:30 2.269
1/15/2016 7:50 2.546 15/1/2016 21:45 2.223
1/15/2016 8:00 2.526 15/1/2016 22:00 2.171
1/15/2016 8:10 2.546 15/1/2016 22:15 2.109
1/15/2016 8:20 2.556 15/1/2016 22:30 1.995
1/15/2016 8:30 2.566 15/1/2016 22:45 1.903
1/15/2016 8:40 2.546 15/1/2016 23:00 1.815
1/15/2016 8:50 2.536 15/1/2016 23:15 1.747
1/15/2016 9:00 2.516 15/1/2016 23:30 1.662
1/15/2016 9:10 2.486 15/1/2016 23:45 1.555
1/15/2016 9:20 2.516
1/15/2016 9:30 2.446
1/15/2016 9:40 2.396
1/15/2016 9:50 2.366
1/15/2016 10:00 2.306
1/15/2016 10:10 2.266
1/15/2016 10:20 2.206
1/15/2016 10:30 2.156
1/15/2016 10:40 2.086
1/15/2016 10:50 2.026
1/15/2016 11:00 1.966
1/15/2016 11:10 1.876
1/15/2016 11:20 1.816
1/15/2016 11:30 1.746
1/15/2016 11:40 1.706
1/15/2016 11:50 1.646
1/15/2016 12:00 1.596
1/15/2016 12:10 1.546
1/15/2016 12:20 1.486
1/15/2016 12:30 1.436
1/15/2016 12:40 1.366
1/15/2016 12:50 1.306
1/15/2016 13:00 1.336
1/15/2016 13:10 1.226
1/15/2016 13:20 1.196
1/15/2016 13:30 1.186
1/15/2016 13:40 1.166
1/15/2016 13:50 1.126
1/15/2016 14:00 1.126
1/15/2016 14:10 1.136
1/15/2016 14:20 1.126
1/15/2016 14:30 1.136
1/15/2016 14:40 1.146
1/15/2016 14:50 1.156
1/15/2016 15:00 1.166
1/15/2016 15:10 1.186
1/15/2016 15:20 1.246
1/15/2016 15:30 1.236
1/15/2016 15:40 1.276
1/15/2016 15:50 1.286
1/15/2016 16:00 1.346
1/15/2016 16:10 1.386
1/15/2016 16:20 1.446
1/15/2016 16:30 1.466
1/15/2016 16:40 1.536
1/15/2016 16:50 1.586
1/15/2016 17:00 1.616
1/15/2016 17:10 1.696
1/15/2016 17:20 1.766
1/15/2016 17:30 1.806
1/15/2016 17:40 1.846
1/15/2016 17:50 1.916
1/15/2016 18:00 1.966
1/15/2016 18:10 1.996
1/15/2016 18:20 2.066
1/15/2016 18:30 2.126
1/15/2016 18:40 2.146
1/15/2016 18:50 2.196
1/15/2016 19:00 2.226
1/15/2016 19:10 2.256
1/15/2016 19:20 2.266
1/15/2016 19:30 2.306
1/15/2016 19:40 2.326
1/15/2016 19:50 2.346
1/15/2016 20:00 2.356
1/15/2016 20:10 2.356
1/15/2016 20:20 2.366
1/15/2016 20:30 2.376
1/15/2016 20:40 2.356
1/15/2016 20:50 2.366
1/15/2016 21:00 2.346
1/15/2016 21:10 2.326
1/15/2016 21:20 2.286
1/15/2016 21:30 2.246
1/15/2016 21:40 2.236
1/15/2016 21:50 2.196
1/15/2016 22:00 2.156
1/15/2016 22:10 2.076
1/15/2016 22:20 2.056
1/15/2016 22:30 1.996
1/15/2016 22:40 1.926
1/15/2016 22:50 1.866
1/15/2016 23:00 1.826
1/15/2016 23:10 1.736
1/15/2016 23:20 1.696
1/15/2016 23:30 1.666
1/15/2016 23:40 1.586
1/15/2016 23:50 1.526
That suggests to me that you are storing your dates and times in separate columns, instead of combining them into a single date+time serial number -- it can be difficult to see when all you are giving us is copied text into the forum.I know that i can show two line in scatter line but what can i do with the date change AS BELOW when the date change all the next hour heights are shown in previous 24th hour of the day before
1) I would suggest that you start by studying a page like this http://www.cpearson.com/Excel/datetime.htm#SerialDates until you have a good understanding of how Excel stores dates and times as serial numbers.
2) Check your date and time columns to make sure they are real dates/times and not text string that look like dates and times. You can use the ISTEXT() and/or the ISNUMBER() functions (https://support.office.com/en-us/art...1-63f26a86c0eb under Information functions). I like to temporarily remove the date time formatting so I can see the underlying serial number, too (number format dialog -> set to General).
2a) If they are text and not numbers, then you need to figure out why they are text. Remove and leading trailing spaces/non-printing characters. A VALUE() function DATEVALUE() or TIMEVALUE() (see above help file under Date/Time functions) may be useful here.
3) Combine Date and Time into a single column. Once you know that they are real date and time values, this should be as easy as =datecell+timecell. You also might visit the data entry/data importation step and see if you can have the data entered/imported in a way that combines data and time correctly at that point.
4) Once date and time are correctly combined, a simple scatter plot should do the job.
I was finally able to find this thread, that includes a sample sheet I created to show how to plot date+time information on a scatter chart. http://www.excelforum.com/excel-char...ly-0-00-a.html
Note how my spreadsheet has both date and time in the same cell (as date/time serial numbers). My sample only shows one data series. Two data series should be accomplished by simply adding a second data series (both y and x values) to the chart.
hi thank you so much for your help and the time you devoted for helping me
as you said i combined to first column to get one column and cutomised it in mm/d/yyyy h:mm format
but i want exactly as your excel worksheet(mrshorty.....xls) scatter graph
my x axis is labled with number not with my date time column it could be because of my axis format i saw that your x axis format is different and fixed date time(serial date)
please help me
Without seeing your spreadsheet, I cannot say with certainty what you are doing to cause this. The first reason I think of for this is that there is text somewhere in either of your X values ranges. A single text value in either X-values range can cause Excel to treat them as count numbers rather than the actual date/time values. Perhaps you are using a formula for these and, in the shorter data set, it is returning empty string "" or space " " for the missing data points. These are text strings that will cause problems for your chart (if this is the case, then I recommend this essay http://peltiertech.com/mind-the-gap-...g-empty-cells/ ).my x axis is labled with number not with my date time
My first recommendation is to go through your x-values very carefully and make sure there are no text strings or other non-numeric data in those ranges.
hi
i m writing to say that finally i succeeded and thank you for your guidance
(i reopened my text file and checked the import wizard step 3 for date m/d/y)
with best wishes
hi again
another thing that happened was about date format cell that PETE_UK has answered it in this thread.thanks him too
http://www.excelforum.com/excel-form...rmat-cell.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks