HomeMicrosoft OfficeHow To Save Graphs In Excel As Images

How To Save Graphs In Excel As Images

Microsoft Excel is a spreadsheet application specifically for processing data, both text and numbers. An Excel worksheet consists of rows and columns (grids).

To support daily work, Excel is mostly used only to create or organize data in tabular form so that it is presented more neatly and is easy to read. However, Excel’s real power lies in formulas and functions.

- Advertisement -

Excel formulas and functions are mostly used by advanced Excel users to process data. From the data processor, information is obtained in the form of processed data.

The presentation of information in the form of data is sometimes difficult for some people to digest or understand. Related to this, Excel also has the ability to generate graphs from existing data.

Read articles:

There are some people who find it easier to absorb information in the form of charts and graphics. Sharing Excel files is the usual way.

However, some people may need the graphics more, for example for presentation purposes or complete documents in other Microsoft Office applications.

- Advertisement -

There are several ways to save or extract only existing charts in Excel. You can use copy and paste as Picture technique. This method is considered the easiest.

The next method is to save the Excel file as a Webpage file and then copy the graphics in the file. Following are the steps in Microsoft Excel 2016:

Read articles:

How To Save Graphs In Excel As Images

The following are two methods that you can choose from to save graphics and charts as images in Microsoft Excel. Choose which method you think is best. And make sure you follow all of them. come on !

1. Using the Copy and paste as image technique

Open an Excel file or document that has a graph derived from certain data. Right-click on the graphic border and then select Copy.

Extract fetch graph in Microsoft Excel As image
Extract fetch graph in Microsoft Excel As image

Open another Microsoft Office application, such as Microsoft Word. Right-click in an empty area of ​​the Word document, in the Paste Options section, select Picture.

Paste graph in Microsoft Excel As image Easily
Paste graph in Microsoft Excel As image Easily
- Advertisement -

It can now be seen that the graph from the Microsoft Excel file has been added or displayed in the Microsoft Word document.

Paste graph of Microsoft Excel As image
Paste graph of Microsoft Excel As image

2. Save as webpage

To save a Microsoft Excel file or document as a webpage file, click the File menu, select Save As and then click Browse.

From the Save As dialog box that appears, specify the storage folder (1), name the file (2), select Web Page (*.html;*.htm) as the save file type (3), make sure you select the Entire Workbook radio button ( 4) and then click the Save button (5).

Save Microsoft Excel Document As Web Page
Save Microsoft Excel Document As Web Page

Launch File Explorer and navigate to the folder where the webpage file is stored. In this folder, there is another folder and a file with an .htm extension.

Double click on the folder to open the files contained in it. You can see two graphic images with .png extension. You can copy the graphic image for further use.

Save Image Microsoft Excel As Web Page
Save Image Microsoft Excel As Web Page
- Advertisement -

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Must Read

Fix Bootloop On Android & Learn The Causes Of bootloop

Fix Bootloop On Android & Learn The Causes Of bootloop

0
Bootloop is a nightmare for all Android device owners. When experiencing a bootloop, the device will continue to spin on the boot screen and cannot...
Skip to toolbar