Spreadsheet.com supports more than a dozen different types of charts, giving you more ways to visualize your data beyond the spreadsheet grid.
Like Kanban views and Gantt charts, Spreadsheet.com’s charts give you more ways to visualize your data beyond the spreadsheet grid. Adding charts to a workbook can help you identify important statistics and trends on your data that may not be obvious when only looking at numbers and provide a more viewer-friendly way to understand your data when you share workbooks with a wider audience.
Charts that you add to your workbook can be resized and moved anywhere on the Sheet view. You can also edit and delete a chart after it's been created, as well as download the chart as a standalone file.
How to Move and Resize Charts
Like floating images,charts can only be added to Sheet views and the grid portion of Gantt views. Charts float over the grid and live outside of cells. Also like floating images, charts can be resized and moved around the sheet.
To move a chart, simply click, drag, and drop the chart into position. To resize a chart, click on it and hold and drag the drag handles on the sides and corners of the chart.
Charts can also be copied or cut, and pasted into the current worksheet or any other worksheet within a workbook. Charts that are pasted into a different worksheet than they were originally created in will continue to reference the same columns and ranges of cells.
Charts cannot be copied or cut and pasted into different workbooks, only to different worksheets within the same workbook.
How to Edit, Delete, and Download Charts
Once you’ve created a chart, you can edit it or delete it from your worksheet, as well as download the chart as a standalone file. You can access all of these options by clicking the three-dot icon in the corner of your chart.
How to Edit an Existing Chart
To edit an existing chart, click “Edit chart” from the options dropdown, or double click the chart itself. This will open the Chart settings panel where you originally configured your chart. Here, you can change the chart type, edit the chart’s data, and change the chart’s visual appearance.
How to Delete an Existing Chart
To delete an existing chart, click “Delete chart” from the options dropdown, or select the chart and press the Delete key on your keyboard. This will delete the chart from your worksheet. All of the data used in the chart will be retained in your workbook.
Undo and redo are available for all chart actions, allowing you to recover changes made to a chart, including deletion, resizing, and more.
How to Download a Chart as a Standalone File
Spreadsheet.com allows you to download your charts as standalone files. Navigate to “Download >” in the options dropdown and select one of the four supported file types. Charts can be downloaded as image files (.jpeg and .png), a PDF file, or a scalable vector (.svg).
Once you select a file type, it will be downloaded to your computer’s downloads file.
Ready to create a chart? Refer back to our article on creating a new chart, or read on to learn about the more than a dozen different chart types supported by Spreadsheet.com, including pie charts, line charts, column charts, and bar charts.