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.
Download the Practice Workbook
You can download the Excel file from the following link and practice along with it.
5 Ways to Print Graph in Excel
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. Use the Print Command in the File Tab to Print a 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. Use the Page Layout Tab to Print a Graph in Excel
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.
3. Use the Move Chart Command to Print a Graph on a 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.
- How to Not Print Empty Cells in Excel (3 Simple Methods)
- Excel VBA: How to Set Print Area Dynamically (7 Ways)
- How to Keep Header in Excel When Printing (3 Ways)
- Print Specific Sheets Using VBA Macro in Excel (4 Ways)
- How to Print Page Number in Excel (5 Easy Ways)
4. Shortcut to Print a Graph in Excel
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.
Related Content: How to Print Gridlines in Excel (2 Ways)
5. Use VBA Code to Print Multiple Graphs in Excel
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.
Related Content: Excel VBA: Set Print Area for Multiple Ranges (5 Examples)
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.
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. And please visit our website Exceldemy to explore more.