overlay two time series with different data amount in chart

  • Thread starter Thread starter Nicolas Dickreuter
  • Start date Start date
N

Nicolas Dickreuter

I have the stock quotes of two different companies. Of stock A I have daily
data and of stock B I only have weekly data. I'd like to overlay the two
companies' stock quotes in a diagram.

How do I have to configure excel for that it stretches the quote for the
company for which I only have weekly data?

any help is appreciated?
Nicolas
 
Nicolas,

This might be a little klutzy, but see if it works for you. Make a copy of
each company's data:

For Company A:

Jan 1 200
Jan 2 201
Jan 3 200
Jan 4 199

For Company B:

Jan 1 222
Jan 8 233
Jan 15 232
Jan 4 221

Note the empty column. Now paste (or link) one directly under the other and
sort them by the date column:

Date A B
Jan 1 200
Jan 1 222
Jan 2 201
Jan 3 200
Jan 4 199
Jan 5 199
Jan 6 198
jan 7 194
Jan 8 182
Jan 8 233
Jan 9 178
Jan 10 155

Now make the chart.
 
Back
Top