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

Get FREE Advanced Excel Exercises with Solutions!

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.


Definition of 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: Step-by-Step Procedures

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

Read More: How to Print Graph in Excel


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

Read More: How to Refresh Chart in Excel


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


Download Practice Workbook

You can download the practice workbook from the link below.


Conclusion

I hope this article on how to embed charts 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.


<< Go Back To Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo