✦Template Printable Ideas Insights

How to Print Graph Only in Excel

By

In Excel, printing only a graph, and not the rest of the worksheet data, can save ink and prevent clutter in reports. This is particularly useful when you want to present only the visual representation of your data. Here's a step-by-step guide on how to achieve this:

Before we dive into the steps, ensure you have your graph already inserted within your worksheet. Let's get started with printing just the graph.

Selecting the Graph

First, you need to select the graph you want to print. This might seem obvious, but Excel allows multiple graphs, so making sure the correct one is selected is crucial.

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
How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)

To select the graph, simply click on it. A border will appear around your selected graph, indicating that it's ready for printing. If you want to print multiple graphs, you can select them by holding down the Ctrl key (or Cmd on a Mac) and clicking on each graph.

Printing the Selected Graph

Once your graph is selected, it's time to initiate the printing process. Here's how you can do it:

How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How to make line chart or graph in Excel
How to make line chart or graph in Excel
How to Make a Graph from Excel - Lindsay Bowden
How to Make a Graph from Excel - Lindsay Bowden

1. Press Ctrl + P (or Cmd + P on a Mac) to open the Print dialog box. Alternatively, you can go to the 'File' menu and select 'Print'.

Adjusting Print Settings

In the Print dialog box, you'll see several options. The key ones to adjust for printing only a graph are:

  • Print what: Make sure 'Selection' is selected instead of 'Active sheet(s)'. This ensures only the selected graph will be printed.
  • Scale to fit paper: Uncheck this box to maintain the size of your graph and fit it to the printer paper width.
  • Fit to: From the drop-down menu, choose '1 page wide'. This ensures your entire graph is printed, even if it's wider than the paper.

After adjusting these settings, click on 'Print' to send your graph to the printer.

How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How to Print Graph Paper in Excel | Techwalla
How to Print Graph Paper in Excel | Techwalla
A step-by-step guide to making a graph on Excel
A step-by-step guide to making a graph on Excel
How to Create a Graph in Excel
How to Create a Graph in Excel
How To Build Your Excel Charts & Graphs Easily (Beginners)
How To Build Your Excel Charts & Graphs Easily (Beginners)
How to Make Charts and Graphs in Excel | Smartsheet
How to Make Charts and Graphs in Excel | Smartsheet

Printing to a High-Resolution PDF

If you're not printing directly, but instead saving your graph as a PDF, here's how to do it:

1. Follow the same steps as above to select your graph and open the Print dialog box.

Saving as a PDF

Instead of clicking 'Print', click on the 'Change printer settings' button (the tiny printer icon with a downward arrow).

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
two screens showing how to use the line chart
two screens showing how to use the line chart
MS Excel 2016: How to Create a Line Chart
MS Excel 2016: How to Create a Line Chart

2. From the available printers, select 'Save as PDF'.

3. Give your PDF a name, choose a location to save it, then click 'Save'.

Your graph will now be saved as a high-resolution PDF, perfect for large-scale print jobs or digital presentations.

And there you have it! Now you know how to print just a graph in Excel, making your reports easier to read and more visually appealing. Happy printing!