Charts in Cells

1. Overview

You can display mini‑charts directly inside cells using two methods:

  1. SPARKLINE() Function

    The SPARKLINE() function creates a mini‑chart using two parameters:

    • the data point values
    • an array of chart setup parameters

    This is a standard Google Sheets function; its full description is available online. GS-Calc additionally supports the interval and axisstyle parameters.

    Sparkline example

  2. Format → In‑Cell Chart

    The Format → In‑Cell Chart command allows you to create any number of cell mini‑charts with a single click. All parameters and display options are configured automatically.

    By default, this in‑cell format is applied to cells at the end of a data series in a row. However, charts can also be displayed at the beginning of a row series, or above/below a column series — the chart position is determined by the cell’s text alignment.

    Format → In‑Cell Chart menu:

    In‑Cell Chart menu

    Sample in‑cell charts:

    In‑Cell Chart examples