Convert Chart into Image using Macros (VBA) in Excel Office 365!!
Tags: convertchartintoimag, vbamacros
Published: 2021-02-10 09:32:25

---
title: Convert Chart into Image using Macros (VBA) in Excel Office 365!!
published: true
date: 2021-02-01 10:35:19 UTC
tags: ConvertChartintoImag,VBAMacros
canonical_url: https://geekexcel.com/convert-chart-into-image-using-macros-vba-in-excel-office-365/
---

You can easily convert [charts](https://geekexcel.com/excel-charts-types-in-office-365/) into [images in Excel](https://geekexcel.com/insert-multiple-pictures-into-cells-based-on-cell-value-in-excel-office-365/) with the [help of the Macros concept](https://geekexcel.com/insert-a-linked-image-using-macros-vba-in-excel-office-365/). Macros and [VBA](https://geekexcel.com/excel-office-365-vba-overview-definition-and-examples/) can provide a lot of features, so you can achieve your task with several clicks. In this tutorial, we will guide you to know the step-by-step instructions to **Convert Chart into Image using Macros (VBA) in Excel** Office 365.

## Steps to Convert a Chart into Image:

To change a chart into an image, follow the below steps.

- The below-given screenshot has shown the **example chart** that we have in our Excel, and we are going to convert it into an image.

![Example chart](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/EXCEL_xfM9TldFUR.png)<figcaption id="caption-attachment-21620">Example chart</figcaption>

- On the **Developer Tab, select** the **Visual Basic** option under the **Code** section.

![Select the Visual Basic option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-the-Visual-Basic-option.png)<figcaption id="caption-attachment-14695">Select the Visual Basic option</figcaption>

- Then you need to copy and paste the code given below.

VBA code to change Chart into Image using Macros

‘Ensure that you have selected the chart

Sub ConvertChartIntoImage()

ActiveChart.ChartArea.Copy

ActiveSheet.Range(“A1”).Select

‘Change chart into the image

‘Then will be pasted on Cell A1

ActiveSheet.Pictures.Paste.Select

End Sub

- You need to **save the code** by selecting it. Then **close** the **window.**

![Save the code](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/EXCEL_anCZQC6LnS.png)<figcaption id="caption-attachment-21621">Save the code</figcaption>

- You have to open the sheet containing the data. On the **Developer Tab, choose** the **Macros option** in the **Code** section.

![Choose the Macros option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-the-Macros-option-3.png)<figcaption id="caption-attachment-14841">Choose the Macros option</figcaption>

- You need to make sure that your macro is selected and **click** the **Run** button.

![Click Run button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/EXCEL_6Ru4tDbFJY.png)<figcaption id="caption-attachment-21622">Click Run button</figcaption>

- Now, you will see that the selected chart has been changed into an image as shown in the below image.

![Output image](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/EXCEL_ktbwuI5lNX.png)<figcaption id="caption-attachment-21623">Output image</figcaption>

## Conclusion:

In this tutorial, we guided you to know the clear-cut steps to **Convert Chart into Image using Macros (VBA) in Excel** Office 365. Give your **suggestions/feedback** in the below comment section. Let us know if you have any **queries** regarding this tutorial. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Create a Table of Contents using Macros (VBA) in Excel Office 365!](https://geekexcel.com/create-a-table-of-contents-using-macros-vba-in-excel-office-365/)
- [Create the Data Entry Form using Macros (VBA) in Excel Office 365!](https://geekexcel.com/create-the-data-entry-form-using-macros-vba-in-excel-office-365/)
- [How to Convert Text into Speech Using Macros in Excel 365?](https://geekexcel.com/how-to-convert-text-into-speech-using-macros-in-excel-365/)