How to Create Embedded Chart in Excel (with Easy Steps)

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.

embedded chart excel

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.

Add a Series to the Chart


📌 Step 02: Add a Second Series to the Chart

  • Second, select the chart >> pick the Select Data option from the Chart Design tab.

Add a Second Series to the Chart

  • Now, press the Add button to enter a new series.

embedded chart excel

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.

Inserting Marketing Expense


📌 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.

Format the Chart

Eventually, this should generate the chart as shown in the picture below.

embedded chart excel


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.

Moving Embedded Chart into Chart Sheet

In an instant, the Move Chart wizard appears.

  • Now, select the New sheet option >> press the OK button.

Inserting Chart Sheet

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.

Moving Chart Sheet into Embedded Chart

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.

Inserting Embedded Chart

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.

Printing Embedded Chart

  • Lastly, check out the preview and click the Print button to print your embedded chart.

Print Preview


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.

How to Embed Excel Chart into Word Document

  • 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.

Using Shortcut key to Paste


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.

Practice Section


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.

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo