It dynamically adjusts based on the values in column A.

Each bar is colored according to the hex codes in column B, creating a stunning gradient effect.

This dynamic Google Sheets template updates instantly when you modify the numbers in row 103.

Easily customize colors through the conditional formatting menu.

Horizontal bar charts created entirely with formulas.

The secret lies in using the right font—Dela Gothic One—which makes the repeated "|" characters appear as a solid bar. This technique ensures that the chart looks clean and professional while remaining customizable.

Each grid is filled based on formulas and conditional formatting rules, dynamically updating to represent varying percentages for different groups.

This approach is ideal for visually tracking group performance or progress at a glance.

This chart uses a technique that combines filled and outlined bars by adjusting the width parameter.

Setting the width to 0 creates filled bars, while non-zero values generate outlined bars

The formula uses three arrays for sizes, fills, and colors to create a visual representation of data with vector bubbles.

It leverages the SPARKLINE function to generate an array of colorful, circular shapes.

This formula generates dynamic pattern bars with characters overlaid, creating a visual representation using values and colors.

The example uses over 100 distinct patterns, making it highly customizable for data visualization.

Easily create multiple charts at once by copying the formula, with customizable colors to match data values.

Unlike standard charts, this formula enables mass chart production with vector scalability, perfect for automatic plotting in table rows.

Easily create multiple charts at once by copying the formula, with customizable colors to match data values.

Unlike standard charts, this formula enables mass chart production with vector scalability, perfect for automatic plotting in table rows.

Easily create multiple charts at once by copying the formula, with customizable colors to match data values.

Unlike standard charts, this formula enables mass chart production with vector scalability, perfect for automatic plotting in table rows.

Add custom formula-based or hand-written labels for your SPARKLINE.

Play with different font colors, bold-italic options. Add hundreds of bars.

Made of fully customizable formula.

Change labels, and values to update it on the fly. 

Use pre-defined color schemes, or own colors.

Custom labels, colors, completiion percent and scale.

This chart is based on SPARKLINE funcuion, gives you real-time automated view.

This chart supports one or more data series. Each series is represented by a separate circular layer, differentiated by distinct colors.

Customize the number of series and their values to represent various data sets.

Watch as Google Sheets comes to life with dynamic animations driven entirely by formulas!

This live visualization displays the Summer Olympics gold medal statistics over 30 periods.

Add a new value in column A: a dotted border automatically separates it from the previous section.

This feature provides a clear visual distinction between stages or actions, ensuring data is neatly organized and easy to follow.

When a new value appears in column A, a dotted border automatically separates it from the previous section.

This feature provides a clear visual distinction between stages or actions, ensuring data is neatly organized and easy to follow.

The radio buttons are created using an experimental technique, which isn't natively supported.

This innovative solution uses formulas to simulate interactive radio button behavior within Sheets, pushing the boundaries of what is typically possible in this environment.

This checklist template includes a progress bar that visually tracks completion, providing motivational support as items are checked off.

It features an auto-color rule for task groups, making it easy to organize tasks and start new projects quickly.

Searchable list of all sheets.

Search by sheet name or sheet color (blue, red, etc.)

Refresh the list on demand.

Find this feature in the Tools menu of Cooltables Add-on.

This collection uses formulas to loop through each character and replace it with a special 'font.'

Enter your text to get multiple options for your social media.

Creates a HYPERLINK to any place in your Spreadsheet.

Supports named ranges, references, range A1 notations. Use with CUSTOM_SHEET_ID function to get sheet id.

Gradient rainbow, Google Sheets colors, and colors used in number formats.

Compare in dark/light mode, guess color name by HEX-code, lighten/darken given color.

The report shows which items matter most (A), which are in the middle (B), and which need attention (C).

The colored labels help you scan and recognize top performers fast. It lets you use checkbox to select dimensions.

Change Invoice # and get updated invoice with items listed. Design based on official template by Google.

This template contains automated invoice, and sample sheets with data.

This will list all Google Sheet's functions, including the undocumented (hidden).

The list will update automatically with new functions when arrived.