overlay two time series in a chart with different data amound

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
 
A

AlfD

Try leaving blanks for the days when you have no data. Excel (using X
scatter graph) can handle gaps.
Put the dates, data for stock1 and data for stock2 in 3 consecutiv
columns.

Al
 
M

Mark Graesser

Nicolas
If you want to have a line connecting the dots on your graph, then fill in the blank cells with =NA(). This will produce a #N/A error in each of these cells and the chart will completely ignore them

If you want to hide the #N/A in your table, you can use conditional formatting with the font set to white (or whatever background color you have set)

O

If your data is in two seperate tables, with two sets of dates, then you can graph both tables seperately. First create the graph for one set of data, then right click on the graph and select Source Data. Under the Series tab you can add the second series of data

Good Luck
Mark Graesse
[email protected]

----- AlfD > wrote: ----

Try leaving blanks for the days when you have no data. Excel (using X
scatter graph) can handle gaps
Put the dates, data for stock1 and data for stock2 in 3 consecutiv
columns

Al
 
Top