1. Computing

Excel High-Low-Close Stock Market Chart Tutorial

By , About.com Guide

3 of 7

Select 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 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.

©2013 About.com. All rights reserved.