How to Print Graph in Excel (5 Ways)

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.

Use the Print Command in the File Tab to Print a Graph in Excel

Read More: How to Set Print Preview in Excel (6 Options)


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.

Use the Page Layout Tab to Print a Graph in Excel

❹ 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.

Page Setup: Use the Page Layout Tab to Print a Graph in Excel

Read More: How to Adjust Print Settings in Excel (8 Suitable Tricks)


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.

Use the Move Chart Command to Print a Graph on a Full Page

❹ Select New sheet from the Move Chart dialog box.

❺ Finally hit the OK command.

Move Chart Dialog Box: Use the Move Chart Command to Print a Graph on a Full Page

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.

Read More: How to Print Full Page in Excel (4 Simple Ways)


Similar Readings:


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.

Shortcut to Print a Graph in Excel

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.

Use VBA Code to Print Multiple Graphs in Excel

❺ 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.

Conclusion

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.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo