✦Template Printable Ideas Insights

Print Graph Only in Excel for Mac: Quick & Easy Guide

By

Have you ever found yourself in need of extracting just a graph from your Excel worksheet on your Mac, for use in another document or for further analysis? While Excel is powerful with numerous features for data visualization, printing only a specific graph can seem complicated. But don't worry, it's quite straightforward once you know how. Let's dive into the details.

Before we start, ensure you're working with an Excel file that contains the chart you want to print. Here, we'll focus on charts as they're the most common form of visualizations in Excel. We'll guide you through the process step-by-step, using the built-in tools and functions in Excel for macOS to isolate and print your graph efficiently.

Preparing Your Chart for Printing

Your first step is to ensure your graph is ready for printing. This involves separating it from the rest of your data and preparing it as a standalone entity. Here's how you can do this:

How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
How to Create a Graph in Excel
How to Create a Graph in Excel
A step-by-step guide to making a graph on Excel
A step-by-step guide to making a graph on Excel

1. **Select Your Chart**: Click anywhere on the chart to select it. Small squares, called handles, will appear around the edges. These are the tools you'll use to manipulate the graph.

Separating the Chart

Now, let's separate the chart so that it's not connected to your spreadsheet. This will make printing it much simpler.

How To Build Your Excel Charts & Graphs Easily (Beginners)
How To Build Your Excel Charts & Graphs Easily (Beginners)
How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How to Create Interactive Charts and Graphs on Mac Using Numbers
How to Create Interactive Charts and Graphs on Mac Using Numbers

*Right-click* (or *Control-click* on a Mac) within the chart area, then select *Move Chart*. A dashed box will outline the chart, and you can now drag it anywhere on your worksheet. Ensure there's enough space around it for printing.

Adding a Chart Sheet

Another way to separate your chart is by adding it to a new sheet. Here's how:

From the *Home* tab, click on *Move or Copy Chart*. In the dialog box that appears, choose *New Sheet*, name it, and click *OK*. Your chart will now be on a new sheet, separate from your data.

How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)
How to create Graph in Microsoft Excel
How to create Graph in Microsoft Excel
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
MS Excel 2016: How to Create a Line Chart
MS Excel 2016: How to Create a Line Chart
How to Make a Chart in Excel
How to Make a Chart in Excel
How to Make Charts and Graphs in Excel | Smartsheet
How to Make Charts and Graphs in Excel | Smartsheet

Printing the Chart

With your chart now separate, you're ready to print. Here's how to do it:

1. **Select Your Chart**: Click anywhere on the chart to select it. This is important as the default print settings will print your entire worksheet, which isn't what we want.

Setting Up the Print Area

Next, we'll set the print area to just our chart.

Noob to Excel Pro
Noob to Excel Pro
How to take your graph from Excel to Word or PowerPoint
How to take your graph from Excel to Word or PowerPoint
Excel graph
Excel graph

Go to the *File* menu and select *Page Setup*. In the resulting dialog box, under the *Print* tab, you'll see a *Print Range* section. Here, choose *Selection* as the print range. Click *OK* to apply these settings.

Printing the Chart

Now you're ready to print. Go to the *File* menu and select *Print*. In the preview window, ensure the sheet with your chart is the one that will print. Choose your printer settings as usual, then click *Print*.

Congratulations! You've now successfully printed just a graph from Excel on your Mac.

Remember, the key to printing only a graph in Excel on a Mac is to separate the chart from your data, set the print range to just the chart, and then print. With a little practice, you'll be able to do this like a pro.