Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine the two into a single formula please | Excel Worksheet Functions | |||
how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
combine different worksheets to a single worksheet | Excel Discussion (Misc queries) | |||
Combine candle and line in a single chart | Charts and Charting in Excel | |||
Combine candle and line in a single chart | Charts and Charting in Excel |