✦Template Printable Ideas Insights

How to Print a Graph in Excel

By

printer icons in Excel might seem intimidating at first, but printing a graph or chart in Excel is quite straightforward once you know the steps. Excel offers various chart types and formatting options, allowing you to create engaging and informative visuals that can be printed to share insights, present data, or include in reports.

Before we dive into the printing process, let's ensure you have the chart set up correctly. You've selected your data, picked a chart type (like column, bar, line, etc.), and customized it with titles, labels, and colors. Now, you're ready to print your masterpiece. Here's a step-by-step guide to printing a graph in Excel:

Preparing Your Chart for Printing

Before printing, ensure your chart looks perfect. You can adjust the size, add or remove elements, and check the layout. Here's how:

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
How to make line chart or graph in Excel
How to make line chart or graph in Excel

1. **Select your chart** by clicking anywhere inside it. Excel will outline it with a thin, dashed line.

Adjusting Chart Size

Resize your chart using the resize handles (small squares on the chart's border) or enter exact dimensions in the 'Size & Properties' pane on the 'Format Selection' tab (under Chart Tools).

How To Build Your Excel Charts & Graphs Easily (Beginners)
How To Build Your Excel Charts & Graphs Easily (Beginners)
How to Make a Graph from Excel - Lindsay Bowden
How to Make a Graph from Excel - Lindsay Bowden
How to Make Charts and Graphs in Excel | Smartsheet
How to Make Charts and Graphs in Excel | Smartsheet

Here's how you can make your chart wider to better display category axis labels or larger to show more data in series:

  • Click and drag resize handles to the desired size.
  • Or, in 'Size & Properties', enter the desired width and height in inches.

Reviewing and Editing Chart Elements

Check if your chart title, axis titles, and data labels are accurate and well-placed. You can edit them by right-clicking and selecting 'Format Selection' (for titles) or by using the 'Add Data Labels' option in the 'Layout' tab (for data labels).

correcting these elements enhances the chart's readability and understanding, making your printed graph more impactful.

How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)
How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How to Create a Graph in Excel
How to Create a Graph in Excel
How to create Graph in Microsoft Excel
How to create Graph in Microsoft Excel
an image of a computer screen with graphs on it
an image of a computer screen with graphs on it

Printing the Chart

Now that your chart is perfect, it's time to print it. You have two options: print the entire worksheet or just the chart. Let's discuss both:

Printing the Entire Worksheet

Printing the whole worksheet is simple and includes all cell data, graphs, and any other content. Here's how:

1. Press Ctrl + P (Windows) or ⌘ + P (Mac) to open the Print dialog box.

How to Make a Line Graph in Excel - From Simple to Scientific
How to Make a Line Graph in Excel - From Simple to Scientific
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

2. Select the printer you want to use. Choose the number of copies if needed.

3. Click Print.

Printing Only the Chart

For a standalone print of just your chart, follow these steps:

1. Right-click on your chart and select Size and Properties.

2. Under Properties, check the box that says Move chart.

3. Click OK. The chart will be separated from the worksheet.

4. Press Ctrl + P (Windows) or ⌘ + P (Mac) and follow the same printing steps as above.

5. After printing, you can delete the separated chart from your worksheet or move it back if you wish.

That's it! You've successfully printed your Excel graph. Keep experimenting with different chart types and formatting options to create informative and engaging visuals for your printed reports and presentations.