In Excel for Microsoft 365 on Windows, arrange your data in columns as Date, High, Low, and Close, select the range, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > High-Low-Close. Excel creates a stock chart with a vertical line for each day’s high-to-low range and a tick marking the closing price.
What a High-Low-Close Chart Shows
A high-low-close chart is a stock chart used to show how a value moved during each time period. For a share price, the vertical line spans the day’s lowest price to its highest price, while a short horizontal mark identifies the closing price. The chart lets readers compare the daily range and close without plotting every price observed during the day.
The chart does not show the opening price. That distinction matters: a high-low-close chart cannot tell you whether the price opened above or below its close, or how large the opening-to-closing move was. If opening prices are important, use Excel’s Open-High-Low-Close stock chart instead.
Although it is commonly used for financial data, the chart can represent other measurements that have a meaningful high, low, and closing or final value for each period. For example, it might show a daily temperature range and the temperature at a chosen reporting time. The values must describe comparable periods and share the same units.
Prepare the Data in the Required Order
Excel relies on the arrangement of the columns to interpret a stock chart. Put the period or date first, followed by High, Low, and Close. Use one row per period, with a clear header in the first row. Do not insert blank rows between observations or include a total row in the selected range.
For example, a small dataset could look like this:
- Date | High | Low | Close
- Jan 5 | 105 | 98 | 102
- Jan 6 | 108 | 100 | 101
- Jan 7 | 104 | 97 | 99
In this example, each close falls between that period’s low and high, as a closing price normally should. Check that condition in your own data, too. A close outside the reported range may indicate a data-entry mistake, inconsistent units, or mismatched dates. High should be greater than or equal to Low in every row.
Enter dates as real Excel dates rather than text that merely looks like a date. If Excel treats a date as text, the horizontal axis may show categories in an unexpected order or use generic labels. Similarly, make sure the price or measurement columns contain numeric values, not numbers stored as text. A currency symbol can be applied through cell formatting; it is usually better not to type symbols into values themselves.
Create the Chart in Excel for Windows
- Arrange the data in four adjacent columns in the order Date, High, Low, Close, with headers.
- Select the complete range, including the header row and date column.
- Open the Insert tab.
- Choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then select High-Low-Close in the Stock section.
- Check that the dates appear along the horizontal axis and that the chart includes the expected high-low lines and close marks.
If Excel places dates in the legend or otherwise interprets the data incorrectly, select the chart and use Chart Design > Switch Row/Column to check the alternate orientation. For a conventional layout with observations down rows and measurements in columns, the original orientation is generally the intended one. If the chart still looks wrong, verify the data order and selection before changing formatting.
Excel for Mac also offers stock charts from the Insert tab, though the exact arrangement of chart controls can differ by release. In Excel for the web, chart choices and formatting controls may be more limited than in the Windows desktop app; use the desktop version if you cannot find the stock chart type or a needed formatting option.
Read the Chart and Check a Worked Example
Suppose a day has a high of 105, a low of 98, and a close of 102. Its vertical line extends from 98 to 105, and the close tick sits at 102. The line’s total span is 7 units. The position of the close tick within the line provides a quick visual cue: here it is closer to the high than to the low. That observation describes the plotted values; it does not, by itself, explain why the price moved or predict what happens next.
Compare that with a second day whose high is 108, low is 100, and close is 101. Its range is 8 units, one unit wider than the first day’s, but its close is near the bottom of that range. A run of daily marks can reveal changes in ranges and closing levels at a glance. However, a high-low-close chart does not show the path between the high and low, trading volume, or the order in which those extremes occurred.
Read the vertical scale as carefully as the marks. Excel may choose an axis minimum and maximum that make small changes look visually large, particularly when the values occupy a narrow band. A chart’s scale affects visual emphasis, not the underlying observations.
Format the Chart for Clear Reading
Give the chart a descriptive title that names the subject and period, such as Daily closing prices, January. Add axis titles when readers might not know the units. With the chart selected, use Chart Design > Add Chart Element to add titles, gridlines, or a data table where appropriate. Keep labels concise so the chart remains legible.
- Format the vertical axis: Right-click the value axis and choose Format Axis. Set a number format such as currency or decimal places to match the data. If you set bounds manually, choose values that preserve useful context rather than exaggerating routine variation.
- Make dates readable: If labels overlap, widen the chart, reduce label density using the axis formatting options, or display fewer periods. Avoid rotating labels so far that they become difficult to scan.
- Use restrained styling: Choose line and marker colors with enough contrast against the background. Do not rely on color alone to communicate meaning, because the high-low line and close tick should remain distinguishable in a printed or grayscale copy.
- Keep the chart focused: Remove a legend if it adds no useful information, but retain clear axis labels and units. If the chart includes multiple unrelated series, consider whether separate charts would be easier to interpret.
Stock charts are information-dense, so adding several trendlines, labels, and decorative effects can make individual observations harder to see. For a report, include a source and a date range near the chart when those details matter to the reader.
Common Problems and How to Fix Them
A blank or malformed chart is often a data-layout problem rather than a chart-format problem. Use these checks before rebuilding it:
- High and low appear reversed: Confirm the second and third numeric columns are High and Low, in that order, and that the high is not below the low.
- The chart has the wrong stock-chart type: Reinsert it using High-Low-Close, not Open-High-Low-Close or a volume-based type. A chart with the wrong type expects a different number and order of data series.
- Dates are missing or appear as series: Include the date column in the selected range, place it first, and make sure it contains actual date values. Check Chart Design > Switch Row/Column if Excel has assigned rows and columns unexpectedly.
- Some periods do not appear: Look for blank cells, text values in numeric columns, or rows outside the selected range. Confirm that the chart’s source range includes all observations.
- The chart looks misleadingly dramatic: Inspect the vertical axis bounds and units. A narrow scale can make ordinary differences look substantial; a very wide scale can hide useful variation.
Also check for mixed units or inconsistent definitions. For instance, highs and lows taken from one time zone or reporting window should not be combined with closes from another without a clear reason. A chart can be structurally correct and still communicate the wrong thing if its source data is inconsistent.
High-Low-Close Compared with Other Stock Charts
Excel provides several stock chart layouts, each requiring its own data arrangement. Choose the type based on which values you actually have and need to display:
- High-Low-Close: Date, High, Low, Close. Use it when the opening value is not needed.
- Open-High-Low-Close: Date, Open, High, Low, Close. This adds the opening value, so readers can compare open and close as well as the full range.
- Volume-High-Low-Close: Date, Volume, High, Low, Close. This combines volume with the high-low-close information.
- Volume-Open-High-Low-Close: Date, Volume, Open, High, Low, Close. This includes both volume and opening price.
A high-low-close chart is not the same as a candlestick chart. Candlesticks conventionally use opening and closing values to form a body, with a line showing the high-low range. Excel’s Open-High-Low-Close stock chart uses its own stock-chart display conventions and is not a substitute for assuming that a particular candlestick style is present. If the open-to-close relationship is central to your analysis, select the chart type that includes Open and make sure the audience can interpret its marks.
Frequently Asked Questions
How do I make a high-low-close chart in Excel?
Put Date, High, Low, and Close in that column order, select the data including its headers, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > High-Low-Close.
Why can’t I select the High-Low-Close chart?
Check that the selected range contains dates or categories plus three numeric series, in the required order, with headers. Make sure the numeric cells are not stored as text and that you are using an Excel version with the stock chart option available.
Does a high-low-close chart show the opening price?
No. It shows the high, low, and close. To include the opening value, choose the Open-High-Low-Close stock chart and provide an Open column in the required position.
Can I add volume to a high-low-close chart?
Yes. Choose Excel’s Volume-High-Low-Close stock chart and arrange the data as Date, Volume, High, Low, Close. Use the volume-plus-open type if you also need opening values.
What does the vertical line mean?
It represents the distance from that period’s low to its high. The close is shown by a short horizontal tick on the line; the chart does not reveal the sequence of price movements between those values.
Related
- Excel Data Validation List: Can It Show Two Columns?
- Excel Data Validation List With a Blank Option
- Excel Data Validation List Without a Cell Reference?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Table Average Not Working? Fix the Source DataIf a PivotTable average is missing, showing Count, or giving an unexpected result, check the value field’s summary…
- Excel Pivot Chart Pareto: Build and Read OneYes—but Excel cannot create a Pareto chart as a native PivotChart. The practical workaround is to build a…
- How to Adjust Histogram X-Values in ExcelTo adjust a histogram’s x-values in Excel for Microsoft 365 on Windows, select the horizontal axis, open Format…
- Bubble Chart in Excel: Make Each Bubble a Different SizeYes. To make bubbles different sizes in an Excel bubble chart, give each data point its own size…
- Pie Chart Angle Formula: How to Calculate Each SliceThe pie chart angle formula is slice angle = (category value ÷ total of all values) × 360°.…
- Excel Pivot Table Percent Difference: How to Show ChangeTo show percent change in an Excel PivotTable, select a value cell, choose Show Values As > %…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.