Use stock charts in Sheets to better visualize price movements
Google Workspace Updates ·
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:
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.
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.