How to graph series with different timeframes

  • Thread starter Thread starter AlekM
  • Start date Start date
A

AlekM

I have two series. One is quarterly data, the other data is daily. The
are for the same period. How can I plot them on the same graph?

Data is for example

01/01/2004 22.3
04/01/2004 33.4
07/01/2004 22.2


and
01/01/2004 14
01/02/2004 23
01/03/2004 54
...et
 
Hi
try creating a worksheet with the following layou:
A B C
dates date 1 data 2
....

Select all three columns and start the chart wizard
 
Thanks Frank, that may be a quick and simple fix. But I am trying t
graph on the same graph Stock quotes (which don't have a value fo
saturday, sunday or holiday) and Fed fund rate, a data that has a valu
every day in the year. I also want to put several other series, that
have values on monthly, or quarterly data and some on random days. An
all this for a period of 5 years. Going over and creating data for eac
day would provide to be extremly lengthy procedure.

ANy other input would be greatly appreciated
 
Back
Top