Use stock charts in Sheets to better visualize price movements

<p>Google Sheets now supports new types of stock charts, making it easier to visualize price movement over time. Stock charts condense several price points for each time period into a single marker, so you can read a security's full trading range at a glance rather than interpreting separate line series. Users can create and customize the following stock chart types:</p><p></p><ul style="text-align: left;"><li><b>High-Low-Close (HLC): </b>plots the highest price, lowest price, and closing price for each period, showing both the trading range and where the period settled</li><li><b>Open-High-Low-Close (OHLC):</b> adds the opening price, so you can see the full session in one marker and immediately tell whether the period closed up or down</li></ul><p></p><p>Both types are built for the workflows financial analysts already run in Sheets, from tracking equities and commodities to building valuation models on historical price data.</p><p>Sheets stock chart support also comes with enhanced Microsoft Excel import compatibility. Previously, importing Excel files containing stock charts into Sheets would result in these charts being dropped entirely, forcing analysts to rebuild them manually. Now, HLC and OHLC stock charts are accurately preserved when moving files between Excel and Sheets.</p><p><br /></p><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipDpqMdaPaDfJNXP5y0HwbiG-ETOy7viLoauILr3m-y2tFFbjeyGFjMoNIr4nlY49xPOLlrq2OuKLuPWue7JvilGYl8S7Go2OrDTXCErbsGo2MZbQoTk-GhIrZ8POm8Pi9Q_IW2vchLgY18XcNby0KcXI_JleG2GHhU0TFdV407ulsaWm5qTZDduV7uM0/s2048/Use%20stock%20charts%20in%20Sheets%20to%20better%20visualize%20price%20movements%20-%206843.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1280" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipDpqMdaPaDfJNXP5y0HwbiG-ETOy7viLoauILr3m-y2tFFbjeyGFjMoNIr4nlY49xPOLlrq2OuKLuPWue7JvilGYl8S7Go2OrDTXCErbsGo2MZbQoTk-GhIrZ8POm8Pi9Q_IW2vchLgY18XcNby0KcXI_JleG2GHhU0TFdV407ulsaWm5qTZDduV7uM0/s1600/Use%20stock%20charts%20in%20Sheets%20to%20better%20visualize%20price%20movements%20-%206843.png" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><br />User creating a stock chart in Google Sheets</td></tr></tbody></table><h3 style="text-align: left;">Getting started</h3><p></p><ul style="text-align: left;"><li><b>Admins: </b>There is no admin control for this feature.</li><li><b>End users: </b>Visit the Help Center to <a href="https://support.google.com/docs/answer/63824" target="_blank">learn more about adding and editing a chart in Google Sheets</a>.</li></ul><p></p><h3 style="text-align: left;">Rollout pace</h3><p></p><ul style="text-align: left;"><li><a href="https://support.google.com/a/answer/172177" target="_blank">Rapid Release domains:</a> Gradual rollout (up to 15 days for feature visibility) starting on October 5, 2026&nbsp;</li><li><a href="https://support.google.com/a/answer/172177" target="_blank">Scheduled Release domains:</a> Gradual rollout (up to 15 days for feature visibility) starting on October 22, 2026</li></ul><p></p><h3 style="text-align: left;">Availability</h3><p></p><ul style="text-align: left;"><li>Available to all Google Workspace customers and users with personal Google accounts</li></ul><p></p><h3 style="text-align: left;">Resources</h3><p></p><ul style="text-align: left;"><li>Google Docs Editors Help: <a href="https://support.google.com/docs/answer/63824" target="_blank">Add &amp; edit a chart or graph</a></li></ul><p></p>

Publication

Google Workspace Updates blog feed · Government/Regulator

Published

5th October 2026

Original report

workspaceupdates.googleblog.com

ProcIntel stores what the source published in its feed — a headline, a summary and a link. It does not store or reproduce the full article.