Microsoft Excel is the most widely used spreadsheet program today. It offers a multitude of tools that allow creating functions and operations between various values.
One of the most used utilities is that of creating representative graphics of said 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 graphic elements as a JPEG image?
As we advance to the beginning of the text, extract a graph and use it as image format have A lot of advantages. Among them and one of the most important is the compatibility. File extensions .jpg is supported by virtually any device and operating system. Otherwise a document of Excel You need the indicated software to be able to read it.
Second, for modifying a graph inside the program is enough to change the values inside the table reference. Instead, an accurate image of special software for editing. Which will make your presentation Jpeg be less prone to unwanted variations. By last, long, graphic-rich documents in Excel are difficult to display. That is with a presentation of pictures You will achieve a better dynamic 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 in 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 don't worry, it's more than sure that you have them installed on your computer. In the first case we will use an image editor. Once you finish creating the chart, adjust its size to a suitable ratio. Since the .jpg formats are rasterized, which implies that lose quality when enlarged.
Let's see below:
- Press the secondary button of the mouse on the graph. Doing so will open a contextual menu.
- In it select "Copy".
- Open the image editor. Can be Microsoft paint, which comes pre-installed with Windows, although we recommend you, if you have it, Adobe photoshop.
- Once in the workspace, press the combination "Ctrl + V" or press "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 It is very useful when your Excel file has lots of graphics. Perform the transformation with the above method would take you a long time.
That is why this form is more recommended so let's see the steps to do it:
- Once you've finished and saved the spreadsheet, we will repeat the operation, but this time as Web page. To do this press "Save as" in the menu "Archive".
- In the window choose the Location and in the type section it changes by "Web page (* .htm; * html)".
- Press "Save" and go to the file you chose.
- Once there, open the file with your Web navigator.
- Press the right mouse button on the first chart and select "Save Image As".
- Choose where and press "Save".
- Repeat this with all the graphics that you need to keep.
The last method is exclusive to Windows 10, unless you have an external program installed in a previous 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 open excel document where the graphics are located and make 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 click main by the area where the graph is and release.
- It will open a small notice in the bottom corner. Click on it.
- In this new window, press the save icon.
- Select the location and format and again "Save".