How to copy paste graph from excel to word online

Though charts can be created in Word online it is better to create them in Excel especially if you have a lot of data to incorporate. Once the charts are made you can easily integrate them into a word document. This article tutorial takes you through how to copy paste graph from excel to word online.

To copy a graph in Excel select the graph and then use the keyboard shortcut or the copy option in the Home tab. Once you have copied the graph you can paste it into a word document using the paste option available under the home tab. You can also use the keyboard shortcut but this way you will not be able to have a special format.

How to copy paste graph from excel to word online

As you know word online has limited formatting options. When it comes to pasting a chart copied from an excel sheet you will have to manage with the limited options. Here is what options are available and how to paste the graph into the Word online document.

  • Open the Excel sheet that has the graph that you would like to copy. For this, you can log in to Office online and go to Excel or assess the file from the one drive website.
  • Once you have created the graph and have all the data in you can select the graph
  • Selection can be done by clicking on the first cell and then moving the selection across the graph without releasing the click.
  • After the graph is selected use the keyboard shortcut to copy the selection. For Windows use Ctrl + C and for Mac Command + C. You can also use the copy option from the Home tab in the top menu or the copy option in the right-click menu.
  • You can close the Excel sheet or minimize it. The content you copied will be saved on the clipboard.

Pasting the graph into the word online document

  • Now open your word online document. You can log in to Word online, office online, or one drive and access the document you would like to work on.
  • Go to the section in the document where you need to insert the graph.
  • Paste the graph into the document using one of these methods.
how to copy paste graph from excel to word online
  • Click on the Home tab in the top ribbon and click on Paste
  • Use the keyboard shortcut to paste the graph into the document. Use Ctrl + V for Windows and Command + V for Mac.
how to copy paste graph from excel to word online
  • Use Right Click. You will have a dropdown menu.
  • Here you can go to paste and choose from either Paste or Paste text only.
  • Once you have the graph pasted into the document you can save it and exit.

Read How to make all periods bigger on word online

How to copy and paste graph from excel to word on mac?

On the desktop version of Word, you have more formatting options as compared to word online. In this section, we will take you through the steps involved in copy-pasting a graph from excel to word.

  • Open Excel by looking for the file using Finder. If you have the file on Office online login to the site, download the file, and open it.
  • Insert the data required and create the graph. If you already have a graph created move on to the next step.
  • Select the graph by clicking on the first cell and moving to cover all the cells without releasing the click.
  • Once you have selected the graph you will need to copy it. To copy use the keyboard shortcuts Command + C for Mac. You can also copy the content using the copy option from the right-click dropdown menu. Another way of copying the graph is by going to the Home tab in the top ribbon of the document and clicking on Copy.
  • Once you have copied the graph you can minimize or close the excel file. The graph will be on the clipboard.

Pasting the graph into the word document

  • Locate and open the word document you would like to add the graph to.   
how to copy and paste graph from excel to word on mac
  • Click on the Home tab in the top ribbon of the document.

You will see the Paste option under Home. You will have a few options under Paste here is an overview.

  • Keep Source Formatting  â€“ Using this option you will be able to keep the graph format as is.
  • Use Destination Styles â€“ using this option you can update the formatting of the graph in a way as to match the formatting of the destination.
  • Use Destination Theme & Link Data â€“ this option updates the formatting of the graph to match the formatting of the destination and keeps the graph linked to the original worksheet.
  • Keep Source Formatting & Link Data – This option keeps the formatting of the graph exactly as is and keeps the graph linked to the original worksheet. The data will still be linked to the original worksheet, the data in the Word document will update as and when the source Excel worksheet is updated.
  • Picture This option pastes the chart as a picture. If you use this option the graph cannot be edited or updated. You can however replace it with another picture and apply picture formatting.
  • Keep text only – This option only pastes the text and nothing else.

Read How to put a circle in Word online

How to copy and paste a graph from excel to word on Windows?

As there are more formatting options in the desktop version of Word you can easily paste content according to your requirements. This section takes you through the steps involved in copy pasting graphs from excel to word on a Windows system.

  • Locate and open the Excel sheet you would like to copy the graph from. You will find it in the Explorer folder on your computer.
  • If you don’t have the graph ready you can start by creating the graph. If you have the graph ready all you need to do is copy it.
  • To Copy start by selecting the graph. This can be done by clicking and dragging the selection or by using the keyboard. Shift + arrow keys
  • Once you have selected the graph you will need to copy it. To copy use the keyboard shortcuts Ctrl + C. You can also copy the graph using the copy option from the right-click dropdown menu. Alternatively, you could go to the Home tab in the top ribbon of the document and click on Copy.
  • Once you have copied the graph you can minimize or close the excel file. The graph will remain on the clipboard.

Pasting the graph into the word document in Windows

  • Use Explorer to locate and open the word document you would like to add the graph to.
  • You can then go to the Home tab in the top ribbon of the document and click on Paste. You will have a dropdown menu.
How to copy and paste a graph from excel to word on Windows

Here is an overview of the options that are available in the Paste dropdown menu.

  • Keep Source Formatting  â€“ Using this option you will be able to keep the graph format as is.
  • Use Destination Styles â€“ Using this option you can update the formatting of the graph in a way as to match the formatting of the destination.
  • Use Destination Theme & Link Data â€“ This option updates the formatting of the graph to match the formatting of the destination and keeps the graph linked to the original worksheet.
  • Keep Source Formatting & Link Data – This option keeps the formatting of the graph exactly as is and keeps the graph linked to the original worksheet. All the edits made to the original worksheet will show on the copied graph.
  • Picture This option pastes the chart as a picture. The graph cannot be edited or updated. If you need to format the graph you will need to do it on the original file and then copy and paste it again.
  • Keep text only – This option only pastes the text. You will lose the formatting as well as the rows and columns added to the excel sheet.

Read How to change all caps to lowercase in word online?

Can you insert graphs in Word Online on phones and tablets?

Yes, you can insert graphs into word online documents on Android and iOS phones and tablets. As phones and tables use the Word online interface you will not have the advanced pasting features. Here are the steps you can follow to copy past a graph into a document.

  • You will first need to copy the graph from the excel sheet. This can be done by logging into Office online from the browser or by downloading the application.
  • Once you have the file open it and select the graph you need to copy.
  • Now copy the graph.
  • Download the Word application from the Store. This is a free application and does not occupy much space on your device.
  • Login to your office online account so that all the files created and saved using office online are synced on your device.
  • Go to the spot where you would like to insert the graph.
  • Paste the graph into the document using the paste option.
  • You have two main options paste and paste the text. Choose paste

Read How to customize lists in Microsoft word online

How to copy from excel to word without losing formatting?

Like charts and graphs, you can also copy tables and other data from Excel and paste them into a word document. Here are the steps you can follow while pasting data into word from Excel without losing the formatting.

Pasting data in word online without losing formatting

In word online you do not have sophisticated pasting options as you have in the desktop version. This being said here is how you can copy content from Excel and paste it into your Word online document.

  • Locate and open the Excel file you would like to copy text from. If the excel file is saved on the computer you can look for it in the relevant folder. If you have used the online version log in to Office online and then access the file from the excel tab.
  • Now select the content, table, graph, or chart that you would like to copy.
  • Go to the Home tab and click on Copy. You can also copy using the keyboard shortcuts or the right-click menu.
  • Once you have copied the content open the word document you would like to paste it into.
  • Go to the home tab in the top ribbon of the document and click on Paste. You can also use the paste option from the right-click menu or use the keyboard shortcut.
  • Be sure to use ‘paste’ and not the ‘Paste text only’. This way the formatting will not change much. You will lose the alignment but most of it will still be there.

Pasting data in word without losing formatting

When it comes to the desktop version of word the story is a little different. This is because you have more editing tools under the paste tab. Here is how you can copy and paste data from excel to word without losing the formatting.

  • Locate and open the Excel file you would like to copy the data from
  • Select the data that needs to be copied.
  • Copy the data using the Hoe tab, right-click, or keyboard shortcut.
  • Close the excel sheet
  • Locate and open the Word document you would want to paste the data to.
  • Click on Home in the top ribbon of the document
  • Under home click on Paste. You can also click on paste from the right-click menu.
  • Choose the appropriate pasting option to keep the formatting.
  • Save and close the word online document.

Read How to move text to bottom in word online

Conclusion

The desktop version of Word has more formatting options when it comes to pasting graphs that are copied from Excel files. You can select from the different pasting options and see what suits your needs best.

In word online you have basic features but you can surely copy and paste graphs. If you would want to paste content like charts or graphs as well as tables without losing the formatting you will need to do it on the desktop version. This way you have a broader range of pasting tools.

Hope you found this tutorial article interesting and helpful. Check out similar tutorial articles here.