Microsoft Excel is the most widely used spreadsheet program today . It offers a multitude of tools that allow you to create functions and operations between different values.
One of the most widely used utilities is the creation of representative graphics of these numbers. In this way, making a presentation becomes more stimulating and generates more impact than a table of figures.
But it can happen, that sometimes we need to extract these visual pieces of the program . Either to print it or to use it in other types of software. Even on a device without Office . The solution is quite simple and we will show it to you in this post.
Why do I need to save Excel graphical elements as JPEG image?
As we anticipated at the beginning of the text, extracting a graphic and using it as an image format has many advantages . Among them and one of the most important is compatibility . The .jpg file extensions are supported by practically any device and operating system . Otherwise, an Excel document needs the right software to be able to read it.
Second, to modify a graph within the program it is sufficient to change the values within the reference table . Instead, a precise image from special software for editing. Which will make your presentation in JPEG is less prone to unwanted variations . Lastly, long, chart-intensive documents in Excel are difficult to display . That is, with a presentation of images you will achieve better dynamics with fewer resources and a more attractive final result.
Steps to save an Excel chart or table as an image with JPG file extension
Unfortunately, so far the Excel spreadsheet program does not offer a specific tool to export a chart to an image file . So we must use some tricks. Follow one of these three methods to get it.
In all cases we will need external programs . But do not worry, it is more than certain that you have them installed on your computer . In the first case we will use an image editor. After you finish creating the chart, adjust its size to a suitable ratio . Since .jpg formats are rasterized, which implies that they lose quality when enlarged .
Let’s see next:
- Press the secondary button of the mouse on the graph. Doing so will open a context menu .
- In it select “Copy” .
- Open the image editor. It may be Microsoft Paint, which comes pre-installed with Windows, although we recommend, if you have it, Adobe Photoshop .
- Once in the workspace, press the combination “Ctrl + V” or hit “Paste” in the edit bar.
- Go to the file tab and choose “Save As . “
- Select the file type “JPG” or “JPEG”, name it and select the location where the document will be stored.
The second method is very useful when your Excel file has a large number of graphics . Performing the transformation with the previous method would take a long time .
That is why this way is more recommended so let’s see the steps to do it:
- Once you have finished and saved the spreadsheet, we will repeat the operation, but this time as a web page . To do this, click on “Save as” in the “File” menu .
- In the window choose the location and in the type section change to “Web page (* .htm; * html)” .
- Press “Save” and go to the file you chose.
- Once there, open the file with your web browser .
- Right-click on the first graphic and select “Save image as” .
- Choose where and click “Save . “
- Repeat this for all the graphics you need to keep.
The last method is exclusive to Windows 10, unless you have an external program installed in an earlier version. We recommend using it when you need a quick way to store a chart .
However, it is not as accurate as the previous forms and you should have a good pulse:
- It is as simple as opening the Excel document where the charts are located and making sure they appear completely on the screen.
- Then use the keyboard combination “Start button + Shift + S” .
- This will open the selective screen grabber . Drag the main click over the area where the graphic is located and release .
- A small notice will open in the lower corner . Click on it.
- In this new window, press the save icon .
- Select the location and format and again “Save” .