This article demonstrates how to create a stock chart with two series.
The picture above shows a weekly stock bar chart of Microsoft and Caterpillar. One bar shows you the highest price and the lowest price during that specific week, it also shows the closing price which is the price of the last deal done that week.
Rearrange columns like this: high, low and close
Select columns High, Low and close
Go to tab "Insert" on the ribbon
Click "Other Charts" and then "High-Low-Close"
A chart is inserted on your active sheet
Right click on chart and click on "Select Data..."