How To Print A Chart In Google Sheets

In this tutorial, you will learn how to print a chart in Google Sheets.

Google Sheets is a great tool for generating professional charts and graphs from data quickly and easily so it’s frequently used for this purpose. However, in some situations it’s not practical or desirable to share the entire spreadsheet in order to let others view a particular chart. In this case, you might want to print the chart in order to share it more easily or save it for your records, but it’s not immediately obvious how to print only the chart without also printing the rest of the spreadsheet.

Fortunately, Google Sheets makes it easy to print charts. Just follow the steps below

Preparing the Chart

A few quick steps are required before printing the chart

Step 1

Select the chart you want to print , then click on the 3 dots in the upper right corner

Step 2

In the menu that appears, choose Copy Chart to copy the chart to the clipboard

Step 3

Open the Edit menu and choose Paste to paste a duplicate copy of the chart. Don’t worry where you put it or if it obscures important data at this stage

Step 4

Select the new chart copy and click on the 3 dots again, then choose Move to Own Sheet

Step 5

The copy of the chart will be removed from the sheet it’s in and placed in its own sheet, ready to print. Note that all changes made to the source data will affect the original chart and this new, separate chart copy

Printing the Chart

Once you’ve prepared the chart for printing, follow these steps to print it:

Step 1

In the new chart tab created above, open the File menu and choose Print from the bottom

Step 2

In the Print Settings window, be sure the Print area dropdown is set to Current Sheet to print only the chart

Step 3

Make any other desired adjustments to the print settings, then click Next to continue to your browser’s print dialog where you can print the chart just like any other document

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to print a chart in Google Sheets. Want more? Check out all the Google Sheets Tutorials.