Make a High-Low-Close Stock Market Chart in Excel Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
How to Make a High-Low-Close Stock Market Chart in Excel
Track your stocks with Excel
By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on November 24, 2021 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook What to Know
Enter your stock data in the worksheet, including date, volume traded, high price, low price, and closing price.Select the data, select Insert > Recommended Charts > All Charts > Stock > Volume-High-Low-Close > OK.To style the chart, select the chart, go to Design, select chart elements, change the chart style and other design options, and save the chart. This article explains how to track stocks with Excel using a high-low-close chart. Instructions apply to Excel 2019, 2016, 2013, 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, and Excel for Microsoft 365. 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 data into cells A1 to E6 as shown in 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. In Excel 2013 and later, if your data is in continuous cells, as in this example, you can click on any cell in the range, and all of your data will be included in the chart. Otherwise, there are two options for selecting the chart data: by mouse or by keyboard. Using the mouse
Click your mouse on cell A1.Click the left mouse button and drag the mouse to highlight all the cells to D6. Using the keyboard
Click on the top left of the chart data.Hold down the Shift key on the keyboard.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. Click the Insert tab on the ribbon.Click Recommended Charts.Go to the All Charts tab.Select Stock in the list of chart types.Click Volume-High-Low-Close.Click OK. Style and Format the Stock Chart
Format the chart the way you want it to appear. Click the chart to activate the Chart Tools tab of the ribbon.Click the Design tab.Select the chart element you want to format.Choose a different chart style or select other design options, such as fill color, shadow, and 3-D formatting.Save the changes to your chart. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Hide and Unhide Columns, Rows, and Cells in Excel How to Create a Report in Excel How to Make a Schedule in Excel How to Combine the ROUND and SUM Functions in Excel How to Create Exploding Pie Charts in Excel How to Count Data in Selected Cells With Excel's COUNTIF Function How to Limit Rows and Columns in an Excel Worksheet Excel SUMIFS: Sum Only Values Meeting Multiple Criteria How to Create a Histogram in Excel for Windows or Mac Splitting the Screen in Excel The Do's and Don'ts of Entering Data in Excel The 12 Best Tips for Using Excel for Android in 2022 Learn How to Remove Extra Spaces From Excel Using TRIM How to Create an 8 Column Chart in Excel Relative, Absolute, and Mixed Cell References in Excel and Sheets How to Create a Pie Chart on a PowerPoint Slide Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies