Product Documentation
Select a Product:
Not seeing an answer to a question you might have? You can ask it here and we'll try to update the documentation to address it. If you're making a feature request or reporting a problem, please create a support item for it, instead!
RegiaBI Apps, Maps and Charts for Google Sheets
Purpose
It's the same engine as the Power BI visual and the Excel add-in — the same chart catalog, the same plain-English refinement, the same account and the same credits. It's the Excel add-in's own pane, in a different grid, so this page covers what's different here and points to the Excel page for what's the same: what's different in Google Sheets.
Installing it
Install it from the Google Workspace Marketplace, then open any spreadsheet and choose Extensions, the add-in's name, then Open. Nothing is installed on your computer; the add-in loads from our site each time you open it.
The first time, Google asks you to allow two permissions, both narrow: to see and change the spreadsheet you have it open in, and to show its window there. It can't see your other spreadsheets or your Drive. If you leave one unticked, Google asks again the next time you choose Open, because the add-in can't work with only one.
It needs Google Sheets in a desktop browser.
Your first chart
- Get some data in front of it. Click Menu at the top right of the window, then Insert sample data to write a small demo table to a new sheet — or select any range of your own that has a header row, and click Menu > Use selection. With nothing selected, it takes the block of data around the cell you're on.
- Look at what fits. The chart-type list opens by itself once data is bound, ranked for the columns you selected. Highlight a row to ask for that type, or leave every row unhighlighted and let the engine choose. This list costs nothing and reaches no AI.
- Say what you want, if you want. The “What would you like to see?” box takes plain English — “revenue by region, as bars”, “label the top five”. It's optional; leaving it empty is a perfectly good way to work.
- Click Generate. Progress shows in the window and the chart draws there, usually in a minute or two. This is the step that spends credits; everything before it is free.
- Use it. Hover a mark for a tooltip, click one for a card with the numbers behind that selection. Place in sheet puts a picture of the chart on the sheet, two columns to the right of your data.
After that first generation the chart is yours to keep. While the window is open, an edit to a cell, a row typed directly underneath, or rows you hide or filter reach the chart within a few seconds, from the code already in the spreadsheet — with no call to us and no credit. Close the window and it stops reading your spreadsheet; open it again and the chart is drawn from where it was saved.
Before you have an account, See sample charts draws finished charts over our own sample table, one after another, with no sign-in and nothing of yours measured or sent.
The data it reads, what it keeps, and what leaves your spreadsheet
Point the add-in at a rectangular range whose first row is the column headers. Every column below that becomes a field the chart can use. A binding is always a range of cells: the add-in's permissions don't let it see a table or a pivot table as such, only the cells they occupy.
Your rows never leave the spreadsheet. A generation request carries the measured shape of the range — the column headers as they appear in your sheet, the type we inferred for each one, aggregate statistics, and a few short category labels — together with the size of the window in pixels, your settings, your locale and anything you typed in the description box. Click See what's sent on the landing page to read the exact payload, in full, before anything is sent.
What it keeps, and where.
- The chart and your settings are kept in the spreadsheet, in a hidden sheet named
_RegiaBI, so they travel with the file. Deleting that sheet deletes the chart. A second hidden sheet,_RegiaBI_view, holds one formula the add-in uses to tell which rows are hidden or filtered. - Your account link is not in the spreadsheet. Google keeps it for you alone, for that spreadsheet, so sharing the file never shares your sign-in.
- A picture you placed is an ordinary image on the sheet. It doesn't update by itself; pressing Place in sheet again replaces it with the chart as it is now.
Two consequences worth knowing about, both of which come from a spreadsheet being raw rows rather than a semantic model:
- Aggregation is yours to set. Nothing in a sheet has been summarized for you, so the add-in has to decide how to summarize a measure per group. The default sums amounts and averages rates; if a column is a percentage, a rate or an index, set Aggregation to Average or Median. Summing a percentage is the classic wrong answer.
- Dates need to be dates. A cell that holds a real date arrives as a date. A date typed as text, or a date column formatted as a plain number, is charted as text or as a number. Format the column as a date (Format > Number > Date) and click Use selection again.
The Menu
The toolbar folds itself away once a chart is on screen so the chart gets the room. Menu at the top right of the window opens it again.
| Button | Costs a credit | What it does |
|---|---|---|
| Use selection | No | Binds the add-in to the cells you have selected right now. The range summary under the heading tells you what it read. |
| Insert sample data | No | Writes a small demo table to a new sheet and binds to it. Useful for seeing what the product does before pointing it at anything of yours. |
| Refresh | No | Re-reads the bound range and redraws from the code already saved in the spreadsheet. |
| Adjust… | Yes | Opens a box for a change described in words — “make the bars horizontal”, “rotate the labels”, “show it as percentages”. It keeps your chart and applies the change, rather than starting again. |
| Change type | Yes, when you then generate | Goes back to the chart-type list with your data still bound, so you can pick a different type. Nothing is spent until you click Generate. |
| Edit the code | No | Opens this chart's code on your account page in your browser, where you can edit it and save a new version. |
| New chart | No | Returns to the landing page with your data still bound. Nothing is deleted from the service — earlier versions stay on your account page. |
| Place in sheet | No | Puts a picture of the whole chart — its title, legend and notes with it — on the sheet your data is on, two columns to the right of it. Pressing it again replaces that picture rather than adding a second. |
| Settings | No | Aggregation, colors, limits, labels and the rest. Changing a setting never generates on its own. |
A table the add-in draws has an Export of its own. It writes the rows the table is showing, in the order and the columns it shows them, to a new sheet named after the table, right after your data's sheet.
Settings, chart types and refining a chart
These are the Excel add-in's, unchanged, because it's the same pane. Rather than repeat them, here's where each is written out:
- Settings: every knob, its default, and whether it repaints the chart now or steers your next Generate.
- Chart types and refining a chart: what the list offers and why, and the three ways to change a chart you already have.
- The code behind the chart: reading, editing and bringing back a saved version.
Read “workbook” there as your spreadsheet. Two things differ:
- Chart colors, “Follow this spreadsheet”. The palette is grown from the first colored cell fill in your range and, where there is none, from your spreadsheet's theme colors. So there's always a starting color here.
- The chart types are the same set as in Excel. The add-in generates and runs D3 (JavaScript and SVG), so the types that exist only in the Power BI visual's Python, Plotly and Vega lanes aren't offered.
Accounts and licensing
Generating needs a linked account; drawing a chart you've already made doesn't. There's no license key to type into the add-in. Link your account opens a sign-in window on our site in your browser; sign in there and the add-in picks it up by itself a moment later, reading who it's linked to.
The link lasts 30 days. After that, generating asks you to link again; charts already in the spreadsheet keep drawing. It's kept for you alone and never in the file.
No account yet? Choose Link your account, then Sign up. Confirming your email address starts a free 21-day trial. It's the same account, and the same credits, as the Power BI visual and the Excel add-in. Licenses and credits are bought on our site, not through Google.
Whether a chart draws with a watermark follows the same rules as in Excel: what an active license decides. Drawing is never refused.
What's different in Google Sheets
One engine and one account — but the hosts aren't the same place, and pretending otherwise would just cost you time looking for things that aren't there.
| In Google Sheets | In Excel | In Power BI |
|---|---|---|
| The chart is in a window over the spreadsheet, opened from Extensions. Place in sheet puts a picture of it on the sheet. | The chart is an object on the sheet that you can move and resize. | The chart is a visual on a report page. |
| Select a range with a header row. | Select a range with a header row. | Fill the Values, Measures and Group by buckets from the semantic model. |
| It follows your cells within a few seconds, while its window is open. | It follows your cells as they change. | It follows the report's filters and refreshes. |
| Raw rows, so Aggregation is a setting that matters. | Raw rows, so Aggregation is a setting that matters. | DAX measures arrive already evaluated at the grain your fields define. |
| D3 only. The chart set is narrower. | D3 only. The chart set is narrower. | D3, Python (Pyodide), Plotly and Vega lanes, so the full catalog. |
| Clicking a mark pops a card with the numbers behind it. | Clicking a mark pops a card with the numbers behind it. | Clicking a mark cross-filters the rest of the report. |
| The chart is saved in a hidden sheet of the spreadsheet and travels with the file. | The chart is saved in the workbook and travels with the file. | The chart is saved in the report and travels with the .pbix. |
| Colors are seeded from a cell fill in your range, or the spreadsheet's theme. | Colors are seeded from the fill your table style paints. | Colors are seeded from the report theme. |
| No freemium. A 21-day trial, then a license. | No freemium. A 21-day trial, then a license. | A freemium tier exists alongside licensed use. |
If something is not right
| What you see | What is going on |
|---|---|
| Generate is disabled, or the window says no data is selected | Nothing is bound yet. Select a range whose first row is the headers, then Menu > Use selection. The range summary under the heading confirms what it read. |
| “Your link has expired” | The account link lasts 30 days. Menu > New chart shows the landing page, where Link your account is. The chart in the spreadsheet is unaffected. |
| I edited a cell and the chart didn't change | The chart follows your cells while its window is open, a few seconds behind. If it's open and still hasn't caught up, Menu > Refresh re-reads the range. |
| The picture on my sheet is out of date | A placed picture is an image and doesn't update by itself. Open the add-in and press Place in sheet again; it replaces the old one. |
| I changed a setting and the chart did not change | Only the settings marked applies now repaint an existing chart. The rest steer what the engine makes and take effect on your next Generate. |
| The numbers look wrong — a percentage got summed | Set Aggregation to Average or Median. A spreadsheet hands over raw rows, so the add-in has to be told how to summarize a rate. |
| My dates are being charted as text or numbers | Format the column as a date (Format > Number > Date), then Use selection again. |
| Google asks me to authorize it again | One of its two permissions isn't granted. Allow both; it can't read your range without the first or show its window without the second. |
| Something else | The add-in sends a short diagnostic log — build, timings and errors, never your cell values — while it's open. Open Settings, click Send it now, and tell us roughly when it happened on the support page; that's enough for us to find it. |
Google Sheets™ is a trademark of Google LLC.