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!
