This tutorial demonstrates how to print a chart in Excel and Google Sheets.
In this Article
Print Chart Only
Printing a chart from Excel is, in many ways, much simpler than printing a dataset. You can skip steps like setting the print area, adjusting page breaks, column headers, borders, etc. What you see on your screen is what will print.
- Click on the chart to select it, and then in the Ribbon, go to File > Print (or use the CTRL + P shortcut).
- Under Settings, the default option is to Print Selected Chart. Leave that setting (or change it back if necessary), and then click Print.
This just prints your chart, not your data.
Print Chart and Data
To print both the chart and the data (if it is on the same sheet as the chart), just print the sheet where they are both situated. In this scenario, you do have to check Page Setup, and you are more likely to run into printing problems. Follow the steps below to print a chart alongside its data.
- In the Ribbon, go to File > Print.
- Choose Print Active Sheets from the first drop down under Settings, and then click Print.
- You can also select just the chart data and the chart to print if there is other information on the sheet as well. For this option, in Settings, choose Print Selection.
Chart Sheet and Data Sheet
If your chart is in a chart sheet (as opposed to a worksheet), then when you click print, the Settings show Print Active Sheets and just the chart sheet will be shown. If you want to print both the chart sheet and the worksheet where the data is stored, you need to select both sheets.
- Click on the Chart2 sheet tab, and then, holding down the SHIFT key (for consecutive sheets), or the CTRL key (for non-consecutive sheets), click on the Data sheet tab. This groups the sheets.
- Now, in the Ribbon, go to File > Print. Note that the Settings say Print Active Sheets while the navigation buttons show that you have two sheets selected to print.
- Review each page preview, then click Print.
Combine Chart Sheet and Data
- Copy the chart from the chart sheet. Then, paste it next to the data on the other sheet.
- Follow Steps 1–3 from “Print Chart and Data.”
Print Chart in Google Sheets
- To print a chart and the data (if it is on the same sheet) in Google Sheets, click the printer icon in the Toolbar.
- In the Print Settings screen, Current sheet is shown in the Print drop down. Click Next.
- Your sheet is shown in Print Preview. Click the Print button in the bottom-left corner of the screen to print your chart and data.
- To only print the chart (and not the associated data), select the cells in and around your chart.
- Then click the printer icon in the Toolbar.
- In the Print settings screen, in the Print drop down, choose Selected cells, and then click Next to go to Print Preview.
- Click Print.
Chart and Data on Different Sheets
If your chart is in a different sheet to your data, and you want to print both the data and the chart:
- Click on the tab for the first sheet you want to print.
- Then, while holding down the SHIFT key (for consecutive sheets), or the CTRL key (for non-consecutive sheets), select the chart and data sheets to group.
- Click the print icon in the Toolbar to print both sheets as described above.