Create a Stock Market Chart in Excel (2024)

Updated on November 24, 2021

What to Know

Entering and Selecting the Chart Data

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

• Column A is labeled "Date."
• Column B has the heading "Volume Traded."
• Columns C, D, and E are labeled "High Price," "Low Price," and "Closing Price," respectively.

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.

Next, you need to highlight the block of cells from A1 to D6.

Otherwise, there are two options for selecting the chart data: by mouse or by keyboard.

Using the mouse

1. Click your mouse on cell A1.
2. Click the left mouse button and drag the mouse to highlight all the cells to D6.

Using the keyboard

1. Click on the top left of the chart data.
2. Hold down the Shiftkey 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.

Creating a Stock Market Chart

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

1. Clickthe Insert tab on the ribbon.
2. Click Recommended Charts.
3. Go to the All Charts tab.
4. Select Stock in the list of chart types.
5. Click Volume-High-Low-Close.
6. Click OK.

Style and Format the Stock Chart

Format the chart the way you want it to appear.

1. Clickthe chart to activate the Chart Tools tab of the ribbon.
2. Clickthe Design tab.
3. Select the chart element you want to format.
4. Choose a different chart style or select other design options, such as fill color, shadow, and 3-D formatting.
5. Save the changes to your chart.

Was this page helpful?

Thanks for letting us know!

Tell us why!