Excel Hi-Lo-Close Stock Market Chart Tutorial

Excel Stock Market Chart Tutorial

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

One change to creating graphs or charts in Excel 2007 / 2010 from earlier versions is that the Chart Wizard is no longer available.

It has been replaced by chart options listed under the Insert tab of the ribbon.

This tutorial walks you through creating a Hi-Lo-Close stock market chart. A Hi-Lo-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.

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

• Excel Stock Market Chart Overview
• Entering the Graph Data
• Select the Chart Data
• Creating a Basic Stock Market Chart
• Formatting the Stock Chart - Choosing a Style
• Formatting the Stock Chart - Choosing a Shape Style
• Formatting the Stock Chart - Adding a Title to the Stock Chart