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

01
of 07

Excel Stock Market Chart Overview

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

Note: What many of us call a graph is referred to in Excel as a chart.

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 in the topics below will produce a stock market chart similar to the image above.

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

Tutorial Topics

  1. Entering the Graph Data
  2. Select the Chart Data
  3. Creating a Basic Stock Market Chart
  4. Formatting the Stock Chart - Choosing a Style
  5. Formatting the Stock Chart - Choosing a Shape Style
  6. Formatting the Stock Chart - Adding a Title to the Stock Chart
02
of 07

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.

When entering the data, keep these rules in mind:

  • Whenever possible, enter your data in columns as shown in the image above
  • 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

Note: The tutorial does not include the steps for formatting the worksheet as shown in the image above. Information on worksheet formatting options is available in this ​basic Excel formatting tutorial.

Tutorial Steps

Enter the data as seen in the image above into cells A1 to D6.

03
of 07

Selecting the Chart Data

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

Two Options for Selecting the Chart Data

For help with these instructions, see the image example above.

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.

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

Tutorial Steps

  1. Highlight the block of cells from A2 to D6, which includes the column titles and the row headings but not the title, using one of the above methods.
04
of 07

Creating a Basic Stock Market Chart

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

For help with these instructions, see the image example above.

  1. Click on the Insert ribbon tab.
     
  2. Click on a chart category to open the drop down 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.

Tutorial Steps

  1. If you are using Excel 2007 or Excel 2010, click on Insert > Other Charts > Stock > Volume-High-Low-Close in the ribbon
  2. If you are using Excel 2013, click on Insert > Insert Stock, Surface or Radar Charts > Stock > Volume-High-Low-Close in the ribbon
  3. A basic High-Low-Close stock market chart is created and placed on your worksheet. The following pages cover formatting this chart to match the image shown in the first step of this tutorial.
05
of 07

Choosing a Style

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

For help with these instructions, see the image example above.

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

Choosing a Style for the Stock Market Chart

  1. Click on the stock chart.
  2. Click on the Design 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. Choose Style 39.
06
of 07

Choosing a Shape Style

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

For help with these instructions, see the image example above.

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

Tutorial Steps

  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. Choose Intense Effect - Accent 3.
07
of 07

Adding a Title to the Stock Chart

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

For help with these instructions, see the image example above.

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

Tutorial Steps

  1. Click on the Layout tab.
     
  2. Click on 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.