Microsoft Excel provides multiple ways to print a graph or chart. While printing a chart or a graph in Excel, you can change the page orientation to horizontal or vertical. You can also control printing quality, paper size, etc. In this article, you will learn 5 ways to print a graph in Excel with ease.
We have a data table of two columns called the Yearly Revenue Increment.
If we plot a stacked column chart of it, then it looks like the following chart:
Now let’s learn 5 different ways to print the above chart or graph in Microsoft Excel.
1. Applying Print Command to Print Graph in Excel
This method is the most basic one to print a graph in Excel. To learn it, follow the steps below:
❶ First of all, click on the chart/graph that you want to print. Clicking on a chart will select only the chart and exclude everything else.
❷ Then go to the File tab from the main ribbon.
❸ After that choose the Print command from the list of other options.
At this point, you will see a Print Preview of the graph that you’ve selected to print.
❹ Now you need to select a printer. You will find the selection option under the Printer box. From the drop-down menu, you can easily find the printer that you are connected with. You can also tweak the printer settings from the Printer Properties option.
❺ Then you will find a Settings box. You can modify the print settings from here.
- If you want to change the page orientation, you can do it easily from the orientation drop-down. Currently, it is set to Landscape Orientation. You can change it to Portrait Orientation from the drop-down list.
- You can change the paper size of the print. Currently, it is set to Letter. But you can change it to other options from the drop-down list.
❻ Now select the number of print copies of your graph from the Copies box.
❼ When you are done with all the settings, just hit the Print button to start printing the graph.
2. Using Excel Page Layout Tab to Print Graph
You can avail the Page Setup group under the Page Layout tab. From from Page Setup group, you can tweak different print settings and print a graph in Excel.
However, here are the steps to follow:
❶ First of all, click on the Excel graph to select the graph.
❷ Go to the Page Layout tab.
❸ Then click on the Page Setup icon from the Page Setup group.
❹ Select the Page tab on the Page Setup dialog box.
❺ Choose the page orientation either Portrait or Landscape.
❻ Now you can choose the Paper Size and Print Quality from the drop-down list.
❼ Finally, hit the Print button to start printing the graph.
Read More: How to Adjust Print Settings in Excel
3. Using Move Chart Command to Print Graph on Full Page
If you want to print a graph on a full page, then follow the steps below:
❶ Click on the graph to select it.
❷ Go to the Design tab from the main ribbon under the Chart Tools.
❸ From the Location group hit the Move Chart command.
❹ Select New sheet from the Move Chart dialog box.
❺ Finally hit the OK command.
So the chart will move to a new sheet.
❻ Now go to the File tab.
❼ Go to Print from the list of other options.
❽ Tweak required settings and hit the Print command to start printing.
4. Applying Keyboard Shortcut to Print Graph
To use the shortcut key to print a graph in Excel,
❶ First, click on the graph to select the graph.
❷ Press the CTRL + P keys together.
These shortcut keys will take you to the print preview window.
❸ Set up the Printer, tweak the Settings, select the number of print copies.
❹ Finally hit the Print button to start printing.
5. Using Excel VBA Code to Print Multiple Graphs
Using this method you can print multiple graphs in a single workbook. The following VBA code will print all the graphs embedded in a workbook. Each of the graphs will be printed out on a separate page.
To use the code, follow the steps below:
❶ Press ALT + F11 to open the VBA editor.
❷ Go to Insert > Module to create a new module.
❸ Copy the following VBA code and paste it to the VBA editor.
Sub MultipleGraphsPrint() For zxz = 1 To Application.ActiveSheet.ChartObjects.Count Application.ActiveSheet.ChartObjects(zxz).Select Application.ActiveSheet.ChartObjects(zxz).Activate Application.ActiveChart.PrintOut Copies:=1 Next End Sub
❹ Save the code by pressing CTRL + S.
❺ Now press the Run Sub button or hit the F5 key to run the above code.
This code will print all the graphs embedded in a single workbook in Excel. Each of the printed graphs will be on a different page.
Things to Remember
- Use CTRL + P as a hotkey to print.
- You can press ALT + F11 to open the VBA editor.
- Press F5 to run the VBA code.
Download the Practice Workbook
You can download the Excel file from the following link and practice along with it.
To sum up, we have discussed 5 ways to print graphs in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap.
- How to Print Multiple Sheets in Excel
- How to Make Excel Spreadsheet Bigger When Printing
- How to Print Sheet on One Page in Excel
- How to Print Excel Spreadsheet on Multiple Pages
- How to Print Excel Sheet in A4 Size
- How to Print Landscape in Excel
- How to Print Horizontally in Excel
- How to Not Print Empty Cells in Excel
- How to Print Worksheet with Comments in Excel
- How to Print Excel Sheet with Table
- [Fixed!] Cutting Off Text When Printing in Excel
- [Fixed!] Excel Cutting Off Text When Printing to PDF
- [Fixed!] Excel Cutting Off Columns When Printing