A fast and convenient way to build scientific and statistical charts that Google Sheets does not directly offer. FSplots is an easy to use add-on built specifically for the Sheets user who needs more from their data visualizations.

• Split-Color Scatter Plots: Color-code your data points automatically by a custom category split (e.g., age range, gender, test group, or month). For "truth & prediction" data models, it automatically calculates Bias, Mean Absolute Error (MAE), and Correlation. With options to add the unity line (x=y), the best fit line, and the best fit equation & R2 value.

• Bland-Altman Plots: Map data agreement quickly. Includes point-coloring by group splits, with automated Bias & Limits of Agreement lines and values. 

• Custom SD Bar Charts: Generate mean and standard deviation bar charts. Unlike native Google Sheets, every bar gets its own SD error bar value.

• Interquartile Range charts (IQR): Calculates the median and displays the distribution with 3 options for the whiskers: max min, +-1.5 IQR (standard box plot rule) , & custom percentiles.

• 100% Secure & Local Processing: All data formatting and mathematical calculations happen entirely inside your spreadsheet. Your spreadsheet data never leaves your sheet, and there is no activity tracking. Your Google account email address is used only to check your subscription with Stripe.

Core Benefits & How It Works

• Charts Persist: Next time you open your spreadsheet, your advanced charts will still be right there.

• Fully Sharable: When you share your Google Sheet, other users can see, read, and configure the charts

• Standard Chart Options: Because these are built from native charts, double-clicking them opens the standard Google Sheets options you are already used to, for setting titles, adjusting axes, and changing fonts.

• Copy & Paste Friendly: Your generated charts copy and paste into Google Docs or Google Slides just like standard charts.

Who Is This For? 

Built for Sheets users, researchers, data scientists, and analysts who need sound error analysis and split-data visualizations directly inside their native spreadsheet workflow. 

How to Install FSplots in Sheets

• Currently Undergoing Testing. 

• To Install. When testing is complete, you can find it in Sheets like this:
  On the top menu: Extensions > Add-ons > Get Add Ons.
  In the storefront search for "FSplots", "Bland Altman", or "split-color".

• Once installed, you'll find these plots under Extensions > FSplots

How to Use

• Select the columns or rows of data you want to chart

• Extensions > FSplots > {choose the plot you want}

• A side-bar will open, set the rows or columns you want to use and the chart options. Press the button to create the chart. The chart should appear in a few seconds.

  • You can leave the side bar open, change the data and chart options, and press the button again to make another chart.

• Double click the chart to get the usual Sheets chart options, to update the titles, axis lables, axis range, etc. To add numerical values to the mean(SD) bar charts, choose "all series" and check "Data Lables".

Free and premium plots

• Split-color scatter plots are free for personal use. Work or school use, and the premium plots (Ranked Scatter, Bland Altman, Mean(SD) and IQR Box Plot), need an FSplots - Full subscription: US$12 per year plus tax.

• To subscribe, open FSplots > Subscription level and click Subscribe now. After paying, return to your spreadsheet and click Refresh status. The menu then shows "Subscription level: premium".

• Payments are processed by Link, from Stripe, which handles sales tax. Your receipt comes from Link, and your card statement shows LINK.COM* FSPLOTS. To change your card, see your invoices or cancel, use FSplots > Subscription level > Manage subscription, or sign in at link.com.

Notes:

• To get all the benefits of using the standard charts, there are some small differences in formatting from traditional Bland Altman, Mean(SD), & IQR charts, see the screenshots. For example:

  • On the Bland Altman chart, the bias and limits of agreement values are shown in the legend.

  • The x-axis labels on some mean(SD) charts can not be centered.

  • The median-line can not be shown on the IQR chart, but the median-value can be included with the x-axis label.  

Screenshots