Browse » Home
Saturday, March 16, 2013
How to Create a Stock Chart in Excel 2007 With Multiple Stocks
1. Open Excel. Create a new document or open a spreadsheet that already contains stock data.
2. Enter or arrange the stock price data into columns. Each column should represent the changes in a stock's price. For example, if you are creating a chart of daily activity in the stock market for four specific stocks, use the first four columns, A through D. Label the stock name or ticker symbol at the top of each column in row 1, then place the daily price data in the subsequent rows. Do not skip rows or leave any cells blank.
3. Select the entire data set by dragging the mouse from cell A1 to the right through all the stocks' columns and then down through all the rows to the last day of information. When done, the entire data set should be highlighted within the Excel window.
4. Click the 'Insert' tab on the ribbon toolbar at the top of the Excel 2007 window. Locate the 'Charts' group within this tab.
5. Click on the 'Line' chart option and then choose any line chart format that appeals to you. A chart is automatically inserted into the spreadsheet containing all the data you selected. Each column is drawn as a separate line on the chart. The overlapping lines show the different stocks' price moves together in one chart.