How to Make a High-Low-Close Stock Market Chart in Excel

Businesswoman using calculator while analyzing graphs

 

boonchai wedmakawand/Getty Images

 A High-Low-Close chart shows the daily high, low, and closing prices for a stock over a given period of time. Completing the steps below will produce a stock market chart similar to the image shown here.

The initial steps create a basic chart, and the final three steps apply a number of formatting features available under the DesignLayout, and Format tabs of the ribbon.

As a note, what many of us call a graph is actually referred to as a chart in Excel.

01
of 04

Entering the chart data

Entering the Tutorial Data
Entering the Tutorial Data. © Ted French

The first step in creating a High-Low-Close stock market chart is to enter the data into the worksheet. Enter the data into cells A1 to D6 as shown in the image.

When entering the data, keep these rules in mind:

  • Whenever possible, enter your data in columns as shown in the image.
  • Lay out your worksheet with the title for each data series at the top of the column and the data in the cells below.
  • Don't leave blank rows or columns when entering your data as this will create blank areas in the chart.

This tutorial doesn't include the steps for formatting the worksheet as shown in the image. Information on worksheet formatting options is available in the ​basic Excel formatting tutorial.

02
of 04

Selecting the chart data

Excel Stock Market Chart
Excel Stock Market Chart. © Ted French

Highlight the block of cells from A2 to D6, which includes the column titles and the row headings but not the title. There are two options for selecting the chart data: by mouse or by keyboard.

Using the mouse

  1. Drag select with the mouse button to highlight the cells containing the data to be included in the chart.

Using the keyboard

  1. Click on the top left of the chart data.
  2. Hold down the Shift key on the keyboard.
  3. Use the arrow keys on the keyboard to select the data to be included in the stock chart.

Be sure to select any column and row titles that you want to be included in the chart.

03
of 04

Creating a basic stock market chart

Excel Stock Market Chart
Excel Stock Market Chart. © Ted French

Follow the steps below to generate a basic High-Low-Close stock market chart. The chart will be created and placed on your worksheet.

  1. Click the Insert ribbon tab.
  2. Click a chart category to open the dropdown list of available chart types (hovering your mouse pointer over a chart type will bring up a description of the chart).
  3. Click on a chart type to select it.

If you are using Excel 2007 or Excel 2010, click on Insert > Other Charts > Stock > Volume-High-Low-Close in the ribbon.

If you are using Excel 2013, click on Insert > Insert Stock, Surface or Radar Charts > Stock > Volume-High-Low-Close in the ribbon.

04
of 04

Style and format the stock chart

Excel Stock Market Chart Tutorial
Excel Stock Market Chart Tutorial. © Ted French

When you click on a chart, three tabs, the Design, Layout, and Format tabs, are added to the ribbon under the Chart Tools title.

Chart style

  1. Click the stock chart.
  2. Click the Design tab.
  3. Click the More down arrow in the bottom right corner of the Chart Styles panel to display all of the available styles.
  4. Choose Style 39.

Chart effect

  1. Click on the chart background.
  2. Click on the Format tab.
  3. Click on the More down arrow in the bottom right corner of the Chart Styles panel to display all of the available styles.
  4. Select Intense Effect - Accent 3.

Chart title

  1. Click the Layout tab.
  2. Click Chart Title under the Labels section.
  3. Select the third option, Above Chart.
  4. Type in the title "The Cookie Shop Daily Stock Value" on two lines.

At this point, your chart should match the stock chart shown in the first step of this tutorial.