✦Template Printable Ideas Insights

How to Print Just the Graph in Excel

By

Have you ever needed to present complex data from an Excel spreadsheet, but found the text and excess data distracting? You might want to focus solely on the graph to tell your story clearly. Unfortunately, Excel doesn't have a built-in feature to print only the graph, but here are some workarounds to help you achieve this.

Before we dive into the steps, ensure your graph is the only object in your workbook or that it's on its own sheet. If not, creating a new sheet with just the graph will make the following steps easier.

Using PowerPoint to Print the Excel Graph

PowerPoint is an excellent tool to print Excel graphs standalone. Here's how to do it:

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

1. Open your PowerPoint presentation. Go to the 'Home' tab, then click on 'Slides from Outline'. This will open a new window with a 'Slide' section.

2. In the 'Slide' section, click on 'Import Slides'. A dialog box will open. Browse and select the Excel file containing the graph and click 'Open'.

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

Selecting and Visually Improving the Graph

3. Once imported, you may notice that the graph isn't the only thing on the slide. To fix this, click on the 'Select' tool (an arrowhead) from the 'Home' tab. Then, click and drag a box around the graph to select it.

4. With the graph selected, go to the 'Design' tab. Here, you can apply different layouts, themes, and effects to your graph. You can also add a chart title or axis labels if needed.

Printing the PowerPoint Slide

5. After customizing the graph, switch to the 'Slide Show' view by clicking the 'Slide Show' tab. Now, go to the 'Set Up' tab and click 'Print'. A dialog box will open, allowing you to choose your printer settings.

How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)
How to Make Charts and Graphs in Excel | Smartsheet
How to Make Charts and Graphs in Excel | Smartsheet
How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How To Build Your Excel Charts & Graphs Easily (Beginners)
How To Build Your Excel Charts & Graphs Easily (Beginners)
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

6. Once you're ready, click 'Print' and your graph will print out on a separate sheet.

Using a Screenshot to Print the Excel Graph

If you prefer a simple method, you can use the screenshot function built into your operating system. This method works on both Windows and macOS:

1. On your keyboard, press the 'PrtScn' or 'Print Screen' key. If you're using a Mac, press 'Command' + 'Shift' + '3'. This will take a screenshot of your entire screen.

MS Excel 2016: How to Create a Line Chart
MS Excel 2016: How to Create a Line Chart
How to Make a Line Graph in Excel - From Simple to Scientific
How to Make a Line Graph in Excel - From Simple to Scientific
How to Make a Chart in Excel
How to Make a Chart in Excel

Cropping the Screenshot

2. Open your image editing software, such as Paint (Windows) or Preview (macOS). Paste the screenshot (Ctrl+V or Cmd+V) and use the cropping tool to select just the graph. Once cropped, save the image.

Printing the Screenshot

3. Open the cropped image file. Go to the 'File' menu, then 'Print'. Choose your printer settings and click 'Print'. Your graph will print out on a separate sheet.

While neither method prints directly from Excel, they both offer a workaround to get your Excel graph printed standalone. PowerPoint provides more control over the final product, while screenshots offer a quick and easy solution. Happy printing!