Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm trying to time series Excel data, how?
I have 2 data columns, both are matched timed series, each point has a gap of
5 hours. Somebody else managed to make excel correlate the raw data and said that they was a lag within the data point, he then set about lagging the data by one day and then said that the lag might be as much as 5 hours, and that I should make excel recognise this....How???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm trying to time series Excel data, how?
Presumably you have a column with date/time for at least one set of the
values. Suppose it's column A. Column B has the set of values correlated with this date/time. Put the other values in column D. In cell E1 put your presumes offset, say, 5:00:00 for five hours. In C1 put a formula like =A1+$E$1, and fill it down column C as far as needed. This is your offset time. Select the data in columns A and B, and make an XY chart (not a line chart). The date/time should be along the X axis. Copy the data in columns C and D, select the chart, and use Edit menu Pate Special to add thee data as a new series, with category values in the first column. Now adjust the value in E1 until the two series line up in the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sam" wrote in message ... I have 2 data columns, both are matched timed series, each point has a gap of 5 hours. Somebody else managed to make excel correlate the raw data and said that they was a lag within the data point, he then set about lagging the data by one day and then said that the lag might be as much as 5 hours, and that I should make excel recognise this....How???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have data in a time series that starts from 0 but i dont want x. | Charts and Charting in Excel | |||
Charting Time Series Data | Charts and Charting in Excel | |||
Lookup function with condition in time series data | Excel Worksheet Functions | |||
Converting between different frequencies for time series data | Excel Discussion (Misc queries) | |||
excel money addin should have time series data | Excel Discussion (Misc queries) |