Combine non-matching dates in single chart
I want to create a chart that represents the development of two
different interest rates. The problem is that the dates associated
with the values of the two variables are not matching each other
exactly. I have hereunder included an example of the data ranges that
I would like to put in one combined chart.
Interest A Interest B
12/17/2006 4.3 12/17/2006 4.8
12/16/2006 4.2 12/16/2006 4.8
12/15/2006 4.2 12/13/2006 4.5
12/14/2006 4.3 12/12/2006 4.4
12/13/2006 4.2
12/11/2006 4.1
You can see that what I want to put on the X-axis are both dates, but
the rates are not measured on the same days. For interest A for
example it is only weekdays, for interest B also Saturdays included,
and some dates are missing in my data set.
I think there must be a way to avoid making any manual changes to put
matching dates next to each other.
Hopefully my explanation of the problem is clear and someone is able
to help me
|