![]() When they are not needed, leave the first or last row blank. Of, if you really need all five points (the last tide from the day before, the three tides on the day of, and the first tide from the day after, simply add another row to the area where you are entering the tide data and enter both the last tide from the day before and the first tide from the day after, as needed. Excel will not display the time (it will show #), because Excel's default 1901 date/time system cannot handle negative times, but the chart will look right, because the underlying value is correct. 13, then you simpley enter =-13/60/24 (which results in a value corresponding to 13 minutes before midnight) and use that for the time value. So, if you wanted to include the last tide from Fri. The same thing could be accomplished entering the last tide from the previous day as "minutes before midnight". Those who have spent a day at the beach probably noticed the constant variations on the level of the sea in relation to the land. They happen in periods of around 6 hours between each other and represent both the highest and lowest level of water of a specific location along the coastline. Excel may automatically change the displayed time to 00:40 in keeping with the hh:mm time format, but the underlying value will be something slightly larger than 1, so that it "fits" into Saturday's time frame. High tides and low tides are stages of the tidal cycle. By understanding this, you should be able to recognize that, to enter the 00:40 time for early Sunday morning so that it fits with Saturdays date, simply enter the time as 24:40 instead of 00:40. I note that you are entering the times as times only (no date information), which means that the actual values are values between 0 and 1. How familiar are you with how Excel stores and uses Date/time data ( ). I prefer to use the Select Data dialog for this action (search help if you do not know where to find the select data dialog in your version of Excel).ĭoes that help at all? What part did I misunderstand (if Ali is right and this requires code, then I must have misunderstood something)? What part do you get stuck on? (list of functions and help files: )ī2) If you intend the plotted point to be elsewhere, then determine how you want to compute Y at A38 and perform that calculation in a convenient cell.Ĭ) Add these values as a second data series. Not sure what this should be.ī1) Maybe you intend this to be along the trendline you have inserted? If so, transfer the coefficients of the trendline to the spreadsheet and use them to compute Y at an X value of A38 or use the LINEST() function to perform the regression in the spreadsheet or use the TREND() function to bypass the coefficients. I'm not sure what "this" should be, but the standard approach to plotting anything on a scatter plot is toĪ) Compute the desired X value (=NOW() in your case, if I am understanding correctly)ī) Compute the desired Y value. ![]() How do I plot this in my this scatter plot chart?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |