Charts
Vector bars with rounded corners made of 1 formula
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.
Made of 1 formula and 1 conditional formatting rule
This dynamic Google Sheets template updates instantly when you modify the numbers in row 103.
Easily customize colors through the conditional formatting menu.
Simple bar chart formula based on char '|' repetition
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.
Percentage values using square grid charts
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.
Vector filled/outlined bars with made of 1 formula
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
Bubble charts with custom color, size, and fill
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.
100+ unique patterns for bar charts
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.
Vector-scalable donut charts formula.
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.
Star percent chart
Vector-scalable heart charts formula
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.
Heart percent chart
Vector-scalable heart charts formula
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.
SPARKLINE bars with labels
Custom labels at the end of bars to level up your bars
Add custom formula-based or hand-written labels for your SPARKLINE.
Play with different font colors, bold-italic options. Add hundreds of bars.
🔴Live Animations
Live animated Summer Olympics gold medal stats
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.
Tools
Conditional borders based on column A values
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.
Conditional borders based on column A values
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.
Experimental radio buttons made of formulas
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.
Checklist to help you start a new project
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.
Sheets Teble of Contents
List of all sheet in your Spreadsheet
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.
😎Get done more with Cooltables!
Cooltables is an essential tool designed to simplify your experience with Google Sheets™. Whether you're dealing with massive datasets or need advanced chart customization like the one above, Cooltables is packed with features to help you optimize your workflow.
Key Features:
Sheets to BigQuery Integration: Load your Sheets data into BigQuery without worrying about cell limits or long loading times. Set it up once, and the add-on remembers your configurations, making future tasks a breeze.
Task History: Track up to 30 previous tasks, easily rename them for quick identification, and replay or modify tasks whenever needed.
Custom Charts & Visualization: Beyond standard features, Cooltables allows you to create stunning visualizations like the SPARKLINE-filled bar chart with rounded corners shown earlier. Customize colors, gradients, and layouts effortlessly.
Innovative Data Detection: Using the built-in "Tabler" script, Cooltables automatically detects table positions, headers, and column data types from your sheets.
With the Cooltables Add-On, you're not just limited to BigQuery integration—you can create visually appealing charts, manage data efficiently, and access upcoming features that will continuously enhance your Sheets experience.
Try the Cooltables Add-On today and discover how it makes working with Google Sheets™ easier, faster, and more enjoyable!