How to Copy/Paste Graphs from Excel into Word or PowerPoint

Updated on: May 13th, 2024

Copying and Pasting, Microsoft Excel, Microsoft PowerPoint, Microsoft Word

Screenshot of instructions discussed in blog post

You’ve got two options.

(Well, if you like to split hairs, there are more options than that. But what if you’re busy and don’t have time to lose? Here are the main copying/pasting options worth paying attention to.)

Option 1: Excel Object

a.k.a. Ann K. Emery’s preferred approach

Instructions

In Excel, create your graph.
In Excel, format your graph. (Declutter; apply brand colors and dark-light contrast; delete the built-in title; re-size the font and graph; etc.)
In Excel, make sure your Theme Colors and Theme Fonts are selected.
In Word or PowerPoint, make sure your Theme Colors and Theme Fonts are selected.
In Excel, copy your chart (CTRL + C, or right-click and select copy).
In Word or PowerPoint, click CTRL + V to paste.
In Word or PowerPoint, add your graph title.

Branding

Colors and fonts will match the destination.

Editing

You can edit the chart in Word/PowerPoint later if needed.

(You can change the colors, size, labels, etc.)

Resolution

Higher.

File Size

Higher.

Linking

You can link your Word/PowerPoint graph back to the Excel file. (Beware! Errors likely!)

Option 2: Image File

Not a fan.

Instructions

In Excel, create your graph.
In Excel, format your graph. (Declutter; apply brand colors and dark-light contrast; delete the built-in title; re-size the font and graph; etc.)
In Excel, make sure your Theme Colors and Theme Fonts are selected.
In Word or PowerPoint, make sure your Theme Colors and Theme Fonts are selected.
In Excel, copy your chart (CTRL + C, or rightclick and select copy).
In Word or PowerPoint, right-click, select paste, and choose the image option.
In Word or PowerPoint, add your graph title.

Branding

Colors and fonts will match the source.

Editing

You can’t edit the chart in Word/PowerPoint later.

(You’d need to edit the chart in Excel, and then re-paste the graph into Word/PowerPoint.)

Resolution

Lower.

File Size

Lower.

Linking

You can’t link your Word/PowerPoint graph back to the Excel file.

(In other words, if you change the graph in Excel, then the image file in Word or PowerPoint won’t look any different.)

Purchase the Cheat Sheet

It’s here: https://depictdatastudio.gumroad.com/l/CopyPasteGraphsFromExcelIntoWordOrPowerPoint

The first 100 people get a complimentary download with code NOMOREGRAINYSCREENSHOTS.

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Soar Beyond the Dusty Shelf Report

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

Enroll

How to Write Dynamic Takeaway Sentences inside Interactive Excel Dashboards

I’m a big fan of takeaway text: for reports, for presentations, and even for interactive dashboards. Sometimes people think that takeaway text isn’t possible for dynamic dashboards in Excel. They worry that they’ll have to write each sentence by hand. False! In this video, you’ll learn about two ingredients: You can write takeaway sentences about: … more »

Great Graphs in Excel

Need practical how-to tips? In this course, you’ll learn how to make great graphs inside software you already have. Includes beginner, intermediate, and advanced tutorials for making charts from start to finish.

Enroll

Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.