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:
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.
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.
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.
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.
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.