My problem may seem simple to some, but it has me a bit perplexed.

It has to do with comparing two different sets of financial data (both
already in Excel 2003) on to a single chart, but their sampling rates are
different (time and money).
1) X-axis (Time): One is sampled weekly and the other is monthly.
2) Y-axis (USD): One is in native USDs and the other is in USDs (x1000).

Is it possible to create the chart referencing the datasets thru links or
will I need to bring copies of the data sets into a single file or worksheet?
If so, please tell me how?

How can I simply get these two distinct datasets represented onto a single
chart/graph that will allow for meaningful comparisons?

Thank you in advance for your assistance.

MJ