View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
daan1903 daan1903 is offline
external usenet poster
 
Posts: 2
Default 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