✦Template Printable Ideas Insights

How to Print Only A Chart in Excel

By

Ever needed to extract a neatly formatted chart from your Excel spreadsheet for a presentation, report, or just to share with colleagues, but didn't want to have to print the entire workbook? You're in luck. Printing only a chart in Excel is a straightforward process that can save you ink, paper, and valuable time. Let's dive into the step-by-step guide to achieve this.

Before we start, ensure that your chart is independently placed on the worksheet. If it's embedded in a table, you'll first need to convert it to a standalone chart. Here's how you can do that:

Preparing Your Chart

If your chart is embedded in a table, follow these steps to convert it into a standalone chart:

How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
How to Make a Chart in Excel
How to Make a Chart in Excel
How To Build Your Excel Charts & Graphs Easily (Beginners)
How To Build Your Excel Charts & Graphs Easily (Beginners)

1. Right-click on the chart and select 'Format Selection'.

2. In the 'Format Selection' panel, click on 'Move Chart'.

How to Make Charts and Graphs in Excel | Smartsheet
How to Make Charts and Graphs in Excel | Smartsheet
Creating AREA Chart in Excel (Easy Steps)
Creating AREA Chart in Excel (Easy Steps)
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel

3. Select 'New Location' and choose the worksheet where you want to place the standalone chart. Click 'OK'.

Step 1: Adjust Your Chart's Size and Position

Before printing, ensure your chart is positioned and sized correctly. You wouldn't want it to be cut off or improperly spaced on the printed page.

1. Click on the chart to select it.

Ever wondered how to create a stunning donut chart in Excel? 🍩
Ever wondered how to create a stunning donut chart in Excel? 🍩
the most useful excel chart info sheet
the most useful excel chart info sheet
Noob to Excel Pro
Noob to Excel Pro
How to make a chart (graph) in Excel and save it as template
How to make a chart (graph) in Excel and save it as template
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
A step-by-step guide to making a graph on Excel
A step-by-step guide to making a graph on Excel

2. Drag the selection boxes at the corners of the chart to resize it.

3. Use the alignment handles (small squares with arrows) around the chart to reposition it.

Step 2: Set Your Print Area

Now that your chart is prepared, let's set the print area to include only the chart:

How to Create a Chart Template in Microsoft Excel
How to Create a Chart Template in Microsoft Excel
an excel spreadsheet in the office window
an excel spreadsheet in the office window
a poster showing how to use chart in excel
a poster showing how to use chart in excel

1. Make sure your chart is selected.

2. Go to the 'Page Layout' tab under the 'Page Setup' group.

3. Click on 'Print Area' and select 'Set Print Area'.

4. A dotted line will now appear around your chart, indicating the print area.

Printing Your Chart

With your print area set, you're ready to print your chart. Here's how:

1. Press 'Ctrl + P' to open the 'Print' dialog box.

2. Ensure 'Print active sheet(s)' is selected.

3. Click 'Print'.

4. Your printer will now only print the selected chart, leaving the rest of the worksheet unprinted.

Bonus Tip: Printing to PDF

If you want to preserve your chart's format and dimensions while sharing it online, consider printing to a PDF instead. Here's how:

1. Follow the same steps to set your print area and open the 'Print' dialog box.

2. Under 'Printer', select 'Microsoft Print to PDF'.

3. Click 'Print'.

4. Choose a location to save your file and click 'Save'.

Now, you have a high-quality, print-ready chart that you can share or use as needed. By mastering this technique, you can enhance your Excel charts' versatility and communicate data more effectively.

Happy printing! Next time, try exploring some advanced chart customizations to truly make your data stand out.