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.
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.
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.
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.
This chart is not natively supported in Sheets!
Made of fully customizable formula.
Change labels, and values to update it on the fly.
Use pre-defined color schemes, or own colors.
Fully costumizable Gantt chart with labels
Custom labels, colors, completiion percent and scale.
This chart is based on SPARKLINE funcuion, gives you real-time automated view.
Multi-Series Circular Progress Chart
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.
🔴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.
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.
Create new 'fonts' and use them as custom text formats on social media.
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.
Hyperlink to cells made easy. Supports named ranges.
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.
Color samples and HEX-codes and handy color formulas.
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.
ABC report with dimension selection
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.
Invoice updated in 1 click
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.
😎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!