Today we’re thrilled to announce the arrival of Charts in Spreadsheet.com, including support for 14 different chart types ranging from Pie and Donut, to Line, Area, Column, Bar, and Combo.

We also redesigned the way borders are rendered, and added non-contiguous selection capabilities for cell styling and multi-series chart creation.

Last but not least, we added 12 new templates to the Spreadsheet.com Template Gallery.

Let’s take a look!

Charts

You can now create charts in any Spreadsheet.com worksheet, with 14 chart types to choose from along with a variety of configuration options.

To create a chart, click the Insert Chart button in the worksheet toolbar, or choose Insert > Chart from the menu bar. A chart’s axes can be defined by selecting columns or ranges in the Setup tab. Chart and axis labels along with legend style and positioning can be changed in the Configuration tab.

For example, here we create a Pie chart based on a Select column and change the legend to appear on the left:

Most chart types include support for aggregation and multiple data series that can be configured to give you the precise view of your data that you're looking for.

For example, here we create a Column chart with data aggregated by a Select column on the X-axis, and two Number columns as series:

For a full introduction and overview of Charts, see Introduction to Charts.

For examples of some some charts in action, check out our updated Simple CRM, Project Plan, Simple Applicant Tracking, and Help Desk Tickets templates.

‍

Chart Types

Pie and Donut Charts are circular graphs divided into “slices”, where each slice is sized proportionally to its data’s share of the data as a whole. For more information about pie charts, see Chart Types: Pie Charts and Donut Charts.

Line and Smooth Line Charts are two-axis graphs displaying a series of data points with straight line segments connecting them. For more information about line charts, see Chart Types: Line Charts and Smooth Line Charts.

Column and Stacked Column Charts are two-axis charts that show rectangular columns with heights proportional to the data they represent. For more information about column charts, see Chart Types: Column Charts, Stacked Column Charts, and 100% Stacked Column Charts.

Area and Stacked Area Charts are two-axis graphs displaying a series of data points with straight line segments connecting them and the area underneath shaded. For more information about area charts, see Chart Types: Area Charts, Stacked Area Charts, and 100% Stacked Area Charts.

Bar and Stacked Bar Charts are two-axis charts that show rectangular bars with lengths proportional to the data they represent. For more information about bar charts, see Chart Types: Bar Charts, Stacked Bar Charts, and 100% Stacked Bar Charts.

Combo Charts are two-axis charts that display one or more column charts with one or more line charts overlaid. For more information about combo charts, see Chart Types: Combo Charts.

Borders 2.0

We rebuilt how borders work in Spreadsheet.com from the ground up. Now borders of all styles and thicknesses render smoothly over the grid rather than inline at cell edges.

See our Product/Market Fit Survey & Analysis template for an example of new border rendering (and charts) in action.

‍

Non-Contiguous Cell Selection

We also added the ability to select non-contiguous cells by holding the CTRL key down and using your mouse to select multiple cells or ranges. Once selected styling actions can be taken on them as a group. Also, when a chart is created from a non-contiguous selection, each range will be treated as a series in the chart.

‍
New Templates

We've added 12 new templates to the Spreadsheet.com Template Gallery for a variety of use cases ranging from HR to G&A, Operations, Nonprofit, Startups, Retail, and Real Estate.

For example, the new Team Objectives & Tasks template is designed for managing tasks and objectives across multiple teams. Monitor the status and progress of projects, assign team leads, and add file attachments directly into cells.

Other newly published templates include:

• Meeting Agenda and Attendees (G&A)
  Create a printable agenda for your meeting with this Meeting Agenda and Attendees template.
  ‍
• Quarterly Goals & Tasks (G&A)
  Track progress toward your team's quarterly goals with related tasks.
  ‍
• New Hire Onboarding Checklist Template (HR)
  Manage contacts, assign team members to onboarding tasks, and track new hire onboarding progress all in one place.
  ‍
• Printable Performance Review Form (HR)
  Evaluate employee performance in key areas such as productivity, collaboration, company values, and more.
  ‍
• Employee Performance Reviews (HR)
  Collect feedback from reviewers and view an overview of all employee reviews in one spreadsheet.
  ‍
• Employee Timesheet (HR)
  With a built-in Form view, employees can easily log clock-in and clock-out times along with break starts and ends from mobile devices.  
  ‍
• Weekly Employee Timesheet (HR)
  Track hours worked per project to gain visibility into how your team is spending their time, or to accurately bill clients for time spent on their projects.
  ‍
• Volunteer Sign-Up (Nonprofit)
  Track and manage volunteer event opportunities and use a built-in Form view to distribute a sign-up form to attendees.
  ‍
• Business Model Canvas (Startups)
  A classic tool for developing new business models and documenting existing ones.
  ‍
• Café and Restaurant Inventory Management (Retail)
  Track bakery items and their selling price. Link items to inventory, and track costs, stock, and sales per item.
  ‍
• House Hunting Organizer (Real Estate)
  Track homes for sale in your search for a house including photos, listing price, HOA fees, estimated mortgage payments, property characteristics, agent contact info, and more.

‍
‍More updates

‍As usual, whenever we release updates to the product we share more details of new features, enhancements, and fixes in the What’s New? section of the Spreadsheet.com Community.  

• Product Updates - March 19, 2022
• Product Updates - February 12, 2022
• Product Updates - December 25, 2021
• Product Updates - December 4, 2021

‍What's next?

A few features we're busy working on now:

• View Sidebar
  We're expanding the worksheet View selector into a pinnable full-length sidebar to make discovering, creating, and navigating between Views easier.
  ‍
• Grouping
  Based on popular request, we're adding the ability to group rows in Sheet and Gantt views by unique values with multiple levels of grouping and rollup summary calculations.
  ‍
• Row Movement
  Ability to drag and drop rows to reposition them in Sheet and Gantt views. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
  ‍
• Gantt View Improvements
  From enabling formulas in project management columns, to support for multiple types of dependencies, we have a whole set of Gantt view and project management improvements coming soon.
  ‍
• Cross-sheet Formula Improvements
  We're redesigning the way cross-sheet formulas are computed, optimizing for both reliability and significant performance improvements.
  ‍
• API
  We're working on publishing an initial version of our REST API that can be used to programmatically interact with Spreadsheet.com workbooks.
  ‍

Stay tuned for more updates coming soon ...