What’s new?
We’re thrilled to announce the launch 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 completely rebuilt how borders are rendered in the grid, and added non-contiguous cell selection capabilities for styling and 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 different unique 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 worksheet menu bar. A chart’s axes can be quickly defined by selecting a column or range in the Setup tab. Chart and axis labels, and 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 reordered to give you the precise view of your data that you are 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.
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 completely rebuilt how borders work. 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 the 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 been busy creating more templates to start from. The following 14 new templates are now available in the Spreadsheet.com Template Gallery.