Creating a Stock chart

Applies to
Microsoft Office Excel 2003
Microsoft Excel 2002

As its name implies, a Stock chart is most often used to illustrate the fluctuation of stock prices. However, this chart may also be used for scientific data. For example, you could use a Stock chart to indicate the fluctuation of daily or annual temperatures.

The way Stock chart data is organized in your worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) is very important. For example, to create a simple high-low-close Stock chart, your data should be arranged with the stock names entered as row headings, and High, Low, and Close entered as column headings, as shown in the following picture.

Picture of worksheet data.

The high-low-close Stock chart below displays the price fluctuation for each stock.

Picture a High-Low-Close stock chart.

Depending on the type of stock chart you want to create, you must include a specific combination of data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) in your worksheet — and put the data series in order — as shown in the following table.

Stock chart type Required data series and order
High-low-close
  • High price
  • Low price
  • Closing price
Open-high-low-close
  • Opening price
  • High price
  • Low price
  • Closing price
Volume-high-low-close
  • Volume traded
  • High price
  • Low price
  • Closing price
Volume-open-high-low-close  
  • Volume traded
  • Opening price
  • High price
  • Low price
  • Closing price

As shown in the following picture, a Stock chart that measures volume has two value axes (axis: A line bordering the chart plot area used as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories.): The value axis on the left shows the volume of stocks traded, and the value axis on the right shows the stock prices.

Volume-High-Low_Close Stock chart

Create a Stock chart

  1. Select the data you want to display in a Stock chart.

 Note   Make sure the data is arranged for the type of Stock chart you want to create, as described in the preceding table.

  1. On the Insert menu, click Chart.
  2. In the Chart type box, click Stock.
  3. Under Chart sub-type, click the type you want to use.

For a quick preview of the chart you are creating, click Press and Hold to View Sample.

  1. Click Next, and continue with steps 2 through 4 of the Chart Wizard.

For help on any of the steps, click the question mark (?) on the Chart Wizard title bar.

 
 
Applies to:
Excel 2003