Enter the Chart Data
The first step in creating a High-Low-Close stock market chart is to enter the data into the worksheet.
When entering the data, keep these rules in mind:
- Whenever possible, enter your data in columns as shown in the image above
- 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
Note: The tutorial does not include the steps for formatting the worksheet as shown in the image above. Information on worksheet formatting options is available in this Basic Excel Formatting Tutorial.
Tutorial Steps:
Enter the data as seen in the image above into cells A1 to D6.
