Use stock charts in Sheets to better visualize price movements

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: High-Low-Close (HLC): plots the highest price, lowest price, and closing price for each period, showing both the trading range and where the period settled Open-High-Low-Close (OHLC): adds the opening price, so you can see the full s