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
Select the chart you want to print , then click on the 3 dots in the upper right corner
In the menu that appears, choose Copy Chart to copy the chart to the clipboard
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
Select the new chart copy and click on the 3 dots again, then choose Move to Own Sheet
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:
In the new chart tab created above, open the File menu and choose Print from the bottom
In the Print Settings window, be sure the Print area dropdown is set to Current Sheet to print only the chart
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
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.
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.