How to Create Stock Chart In Excel? (Step-by-Step)Select the data in the worksheet.Go to INSERT> Stock Chart > Open-High-Low-Close.Now, we will have a chat like the one below.Select the vertical axis and press Ctrl + 1 keys.In the format data series box, make “Minimum” as 50 and “Maximum” 65, and “Major” 1.