How to Create a Stock Chart in Excel 2007 With Multiple Stocks
Microsoft Excel is a versatile piece of software for manipulating data of any kind. It allows data to be easily organized within its columnar structure. Once entered, data may be manipulated using charts, formulas and other features. The program is often used for financial data due to its many built-in functions particular to financial operations. Charting stock data is one use of Excel that is straightforward and popular. Charts can be created to track the prices of a stock or multiple stocks with ease. It is possible to create a stock chart in Excel 2007 with just a few clicks of the mouse.
Other People Are Reading
Instructions
-
-
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.
-
1
References
- Photo Credit stock market analysis screenshot image by .shock from Fotolia.com
More Like This
Comments
-
The title describes creating a "stock chart" with multiple stocks. The instructions create a line chart with multiple lines, which is virtually automatic in Excel. I am trying to overlay candlestick graphs (which are called stock charts in Excel) and this post was a misleading wild goose chase.
