Google Sheets adds HLC and OHLC stock charts
Google Sheets now supports High-Low-Close (HLC) and Open-High-Low-Close (OHLC) stock charts, letting users read a security's full trading range from a single marker instead of separate line series.
According to an October 5, 2026 post on the Google Workspace Updates blog, Google Sheets now supports two new stock chart types: High-Low-Close (HLC) and Open-High-Low-Close (OHLC). These condense several price points per time period into a single marker instead of requiring separate line series.
The two new chart types
- HLC plots the highest, lowest, and closing price for each period, showing the trading range and where the period settled.
- OHLC adds the opening price, so a full session is visible in one marker and it's immediately clear whether the period closed up or down.
Both chart types are meant for workflows already common in Sheets, such as tracking equities and commodities or building valuation models on historical price data.
Better Excel compatibility
Previously, importing an Excel file that contained stock charts into Sheets would drop those charts entirely, forcing users to rebuild them manually. Now HLC and OHLC stock charts are preserved accurately when moving files between Excel and Sheets.
Who gets it and when
- Available to all Google Workspace customers and people with personal Google accounts.
- There is no separate admin control — the feature appears automatically for users.
- Rapid Release domains: gradual rollout starting October 5, 2026, with up to 15 days for full visibility.
- Scheduled Release domains: gradual rollout starting October 22, 2026, also up to 15 days.
Users can create these charts through the normal chart insertion menu in Google Sheets by selecting the HLC or OHLC chart type.