Excel’s powerful graphing feature can add visual depth and clarity to even the most mundane datasets. Keeping this in mind, in this article, we’ll demonstrate a step-by-step guide on how to embed chart in Excel. In addition, we’ll also learn about moving an embedded chart to a chart sheet, printing an embedded chart, and inserting a chart into Microsoft Word documents.
Download Practice Workbook
You can download the practice workbook from the link below.
Definition of Embedded Chart
Let’s dwell a little upon what is an Embedded Chart.
In simple terms, an embedded chart is one where the chart resides in the same worksheet as the dataset. Typically, the default option in Excel embeds the chart in the same worksheet as your dataset. However, if you wish, you can insert the chart into a separate chart sheet.
How to Create Embedded Chart in Excel
Now, creating an embedded chart in Excel involves some easy steps. So, without further delay, let’s dive in!
Let’s say we have the following dataset shown in the B4:D13 cells below. The dataset shows the Month number, the Marketing Expense, and the Revenue in USD respectively.
Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.
📌 Step 01: Add a Series to the Chart
- First and foremost, select the D4:D13 cells, which is the Revenue column.
- Next, hold down the CTRL key and select the B4:B13 cells, which refer to the Month column.
- Then, go to the Insert >> click the Insert Scatter (X,Y) or Bubble Chart drop-down >> choose Scatter with Smooth Lines and Markers option.
📌 Step 02: Add a Second Series to the Chart
- Second, select the chart >> pick the Select Data option from the Chart Design tab.
- Now, press the Add button to enter a new series.
Now, this opens the Edit Series dialog box.
- In turn, enter the Series name, in this case, Marketing Expense.
- Following this, choose the B5:B13 range of cells for the Series X values >> similarly, select the C5:C13 cells for the Series Y values >> hit the OK button.
📌 Step 03: Format the Chart
- Third, you can format the chart using the Chart Elements option.
- In addition to the default selection, you can enable the Axes Title to provide axes names. Here, it is the Month and US Dollar.
- Now, add Chart Title, for example, Breakdown of Revenue and Marketing Expense by Month.
- Then, check the Legend option to show the two series.
- Following this, you can disable the Gridlines option to give your chart a clean look.
Eventually, this should generate the chart as shown in the picture below.
Moving Embedded Chart into Chart Sheet
What if you want to move the embedded chart to a separate worksheet? The next section answers this exact question. So, allow me to demonstrate the process in the steps below.
📌 Steps:
- In the first place, select the chart >> from the Chart Design tab, choose the Move Chart option.
In an instant, the Move Chart wizard appears.
- Now, select the New sheet option >> press the OK button.
That’s it, your chart now resides in a separate worksheet. It’s that simple!
Moving Chart Sheet into Embedded Chart
The previous method shown above works the other way round i.e. you can also move the chart sheet to an embedded chart. So, just follow along.
📌 Steps:
- In a similar manner, select the chart in the chart sheet >> press the Move Chart option.
Now, the Move Chart wizard pops out.
- Next, select the Object in option and enter the name of the sheet where to insert the chart, here it is Creating Embedded Chart >> click the OK button.
Finally, the results should look like the screenshot shown below.
Printing Embedded Chart
Microsoft Excel makes printing charts a straightforward process, therefore, just these simple steps.
📌 Steps:
- To begin with, insert a chart, for instance, we’ve embedded a chart as shown in the image below.
- Then, press the CTRL + P to open the print preview window.
- Lastly, check out the preview and click the Print button to print your embedded chart.
How to Embed Excel Chart into Word Document
Sometimes you may need to insert an embedded chart from Excel into a Word Document. Luckily, this is a simple process that can be done in no time. Hence, let us go through the steps.
📌 Steps:
- First, select the chart >> press the CTRL + C shortcut on your keyboard to copy the chart.
- Next, open a Word document >> move the cursor to the location where you want to insert the chart.
- Finally, press the CTRL + V shortcut to paste the chart into the document.
Practice Section
We have provided a Practice section on the right side of each sheet, so you can practice yourself. Please make sure to do it by yourself.
Conclusion
I hope this article on how to embed chart in Excel will now prompt you to apply them in your Excel spreadsheets more effectively. If you have any questions or feedback, please let me know in the comment section. Or you can check out our other articles related to Excel functions on this website.