comparative charts

[impala096]

Hello there,

Below is a chart comparing the 3 month stock chart for Ford and General Motors. I download stock data which consists of the open, volume, high, low, and close of multiple stocks and I would like the ability to compare them in a similar matter to the picture shown below. Any suggestions to get me started in the right direction?

Thanks,
Impala096

[impala096]

Not much response so maybe I should elaborate a little.

Attached is my progress so far. Now, the only problem is I wanted to have the stock data externally linked but if they are all externally linked and the spreadsheet isn’t opened, it won’t update (the equations are manually edited into the data spreadsheets).

Is there a way to accomplish the same feat while having the data sources externally linked? Thanks for any suggestions.