LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combine the two into a single formula please Steved Excel Worksheet Functions 3 September 8th 05 01:31 AM
how to combine several columns into a single column jims Excel Discussion (Misc queries) 9 August 15th 05 12:00 PM
combine different worksheets to a single worksheet Norman Kong via OfficeKB.com Excel Discussion (Misc queries) 4 April 19th 05 12:46 PM
Combine candle and line in a single chart Bert Charts and Charting in Excel 1 January 20th 05 01:08 PM
Combine candle and line in a single chart Bert Charts and Charting in Excel 4 January 19th 05 07:23 AM


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"