✦Template Printable Ideas Insights

Master Excel on Mac: Print Only Graph in Four Simple Steps

By

Want to print only the graph in your Excel file on a Mac? While Excel doesn't provide a direct print option for just graphs, you can use a workaround to achieve this. Here's a step-by-step guide to help you print only the graph in Excel on your Mac.

Before we start, ensure your graph is inserted in the worksheet and visible. If it's not, select and copy the graph from its original location and paste it into a new worksheet. This will make the printing process more straightforward.

Preparing Your Graph for Printing

First, make sure your graph is the correct size for printing. Excel allows you to adjust the graph size to fit the paper.

How to Make Your Own Graphs - Lindsay Bowden
How to Make Your Own Graphs - Lindsay Bowden
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
A step-by-step guide to making a graph on Excel
A step-by-step guide to making a graph on Excel

To do this, select your graph, go to the 'Design' or 'Format' tab in the ‘Drawing Tools' section, then under 'Size & Properties', select 'Scale to Fit' and choose '100%'. This will ensure your graph prints at its actual size.

Removing Unwanted Data from the Worksheet

Excel prints the entire worksheet by default. To print only the graph, you need to remove or hide all the unwanted data.

How to Create Interactive Charts and Graphs on Mac Using Numbers
How to Create Interactive Charts and Graphs on Mac Using Numbers
How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)
How to Create a Graph in Excel
How to Create a Graph in Excel

First, select and delete any cells or ranges in the worksheet that you don't want to print. Then, hide any empty rows or columns by selecting them, right-clicking, and choosing 'Hide' from the context menu. This will create a blank space around your graph.

Freezing the 'Print Area'

Freezing the 'Print Area' in Excel ensures that only the selected range prints when you open the 'Print' dialog box. This is a more reliable method than simply zooming to 100% and fitting to one page, as it maintains the original graph size.

To freeze the 'Print Area', select the entire range that includes your graph. Then, go to the 'Page Layout' tab, click on the 'Print Area' button in the 'Page Setup' group, and select 'Set Print Area'. This will highlight the selected range in blue, signaling that this is the only area that will print.

How to Make a Graph from Excel - Lindsay Bowden
How to Make a Graph from Excel - Lindsay Bowden
How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How To Make a Quick & Easy Graph in Excel
How To Make a Quick & Easy Graph in Excel
How to Make Charts and Graphs in Excel | Smartsheet
How to Make Charts and Graphs in Excel | Smartsheet
MS Excel 2016: How to Create a Line Chart
MS Excel 2016: How to Create a Line Chart
Create Graph in excel | HOW TO CREATE GRAPH IN EXCEL | MINI GRAPH IN EXCEL | EXCEL TUTORIAL | EXCEL
Create Graph in excel | HOW TO CREATE GRAPH IN EXCEL | MINI GRAPH IN EXCEL | EXCEL TUTORIAL | EXCEL

Printing the Graph

Now that you've prepared your graph for printing, it's time to print it. Here's how:

Press 'Command + P' on your keyboard to open the 'Print' dialog box. You should now see your graph, along with any hidden rows or columns, selected for printing. If everything looks good, click 'Print'.

Printing from 'File' Menu

If you prefer using the menu instead of the keyboard shortcut, you can also access the 'Print' dialog box from the 'File' menu. Here's how:

How to Make a Chart in Excel
How to Make a Chart in Excel
the ultimate guide to create professional chart in excel with infos, graphs and diagrams
the ultimate guide to create professional chart in excel with infos, graphs and diagrams
How To Build Your Excel Charts & Graphs Easily (Beginners)
How To Build Your Excel Charts & Graphs Easily (Beginners)

Click on 'File' in the menu bar, then select 'Print' from the dropdown menu. This will open the same 'Print' dialog box where you can preview and print your graph.

Adjusting Print Settings

You can adjust the print settings, such as paper size, orientation, and scale, by clicking on the 'Page Setup' button in the 'Print' dialog box. This will open the 'Page Setup' dialog box where you can make these adjustments.

Once you're satisfied with the print settings, click 'Print'. Excel will print only the area you've selected, including your graph.

Now you know how to print only the graph in Excel on your Mac. Practice these steps a few times, and you'll be printing graphs like a pro in no time. Happy printing!