Hello friends and welcome again to our channel, “The Teacher”. In this Excel 2016 tutorial video, we will learn about how to Export Excel Charts as Images or Pictures. Sometimes, you might require to share only the charts that you use in Excel Sheets. For whatever reason, you might want to insert these charts in other applications like Word or PowerPoint, or you might like to save a chart as a Picture, so you may insert it in whatever application you may like. So, here are the steps to Export Excel Charts as Images or Pictures.
The easiest method to export a chart as an image into Microsoft Word or PowerPoint is to, first select the entire chart by clicking on the edge and make sure that the entire charts gets selected and not only the part of it. Now, either right-click on the Chart and click Copy from the Context menu, or click the Home Tab and then click Copy button. Switch to Microsoft Word and then from the Home tab, click the Paste drop down button and then choose the option, “Picture”. You can now select the picture and can adjust the size accordingly and can use other Pictures tools, like Wrap Text to place the picture at a desire location. You can also use the same steps, if you want to paste the chart as a picture in Microsoft PowerPoint. But keep in mind that this Chart has been inserted as a Picture into a Word Document. But if you like to save the Chart as a picture alone like in JPEG or PNG format, so you may insert it in any application, then copy the Chart first and then open Paint Brush. Click the Paste button and then resize the chart or page as per requirements.
Now, click the File Menu and then click Save. Type a name and then choose the Save As Type, like JPEG or PNG. The benefit of saving a chart as a picture, you can insert this picture as you simply use other pictures in different applications. One another method to simply save a single or multiple Excel charts as Pictures is to use the Excel Save As option. Click the File menu and the Click Save As. Click the Browse button, choose a Location and then type a File name. From Save As Type drop down menu, select Web Page. If you want to save all the charts of this workbook as pictures then select Entire Workbook, or if you want to save the Charts of the current selected worksheet alone then select Selection: Sheet. Click the Save button. Open the folder and there you have all the images of the workbook separately saved into a folder. Before ending this lesson, let me tell you that in Microsoft Word, PowerPoint and even in Excel, there is another simple way to save a Chart as Picture in JPEG or PNG format.
In Excel, copy the Chart first and then paste it as a Picture. Then right-click on the pasted Picture and then click Save As Picture option from the Context Menu. Choose a Location, type a name and select a file type and there you have the chart saved as a Picture. This way, you can easily save any content, pasted as a picture, into a separate picture file. I hope you will find this video interesting and informative. Do leave a comment, share this video with your friends and don’t forget to hit the like button. Subscribe to The Teacher for more upcoming tutorial videos. Thanks for watching and take care!.