1. Computing

Excel High-Low-Close Stock Market Chart Tutorial

By

1 of 7

Excel Stock Market Chart Overview
Excel Stock Market Chart

Excel Stock Market Chart

© Ted French

Excel Stock Market Chart Tutorial

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

©2014 About.com. All rights reserved.