After reading this article, you will learn how to create a separate chart from a chart in Excel. graphic file(.png, .jpg, .bmp or other format) or export it, for example, to Word document or into a PowerPoint presentation.
Microsoft Excel is one of the most powerful applications for data analysis. In his arsenal there are many tools and functions for visualizing this data. Charts (or graphs) are one such tool. To create a chart in Excel, you just need to select the data and click the chart construction icon in the corresponding section of the menu.
But, speaking of the merits, it is necessary to mention and weaknesses... Unfortunately, there is no easy way in Excel to save a chart as a picture or export it to another document. It would be great if we could just click right click mouse over the graph and see a command like Save as picture or Export... But, since Microsoft Corporation did not take care of creating such functions for us, then we will come up with something on our own.
In this article, I will show 4 ways to save an Excel chart as a picture, which can later be pasted into others. Office documents, including Word and PowerPoint, or use it to create some eye-catching infographics.
Copy the diagram into a graphics editor and save it as a picture
A friend of mine once shared a secret with me: she usually copies her charts from Excel to Paint. She creates a chart and just presses a key PrintScreen, then opens Paint and inserts a screenshot. After that, it cuts off unnecessary areas of the picture and saves the rest of the picture to a file. If you have done the same before, then rather forget it and never use this childish way again! We will act faster and smarter!
For example, in my Excel 2010 I created a beautiful volumetric pie chart which displays demographics of our website visitors, and now I want to export this chart from Excel as a picture. Let's do it together:
Exporting a chart from Excel to Word or PowerPoint
If you need to export a chart from Excel to some other application Office suite for example in Word, PowerPoint or Outlook, it is best to do this through the clipboard.
The main advantage of this method is that in this way a fully functional Excel chart is exported to another file, and not just a picture. The graph will keep the link to the original Excel sheet and will be automatically refreshed when the data on this one changes Excel worksheet... This means that you do not have to copy and paste the chart again every time the data used to build it changes.
Save a chart in Word and PowerPoint as a picture
V Office applications 2007, 2010 and 2013 Excel chart can be copied as picture. At the same time, it will behave like a regular picture and will not be updated. For example, let's export an Excel chart to a Word 2010 document.
Most likely a tool Paste special (Paste Special) is available in more early versions Office, but at that time I did not use it, so I will not argue
Save all charts in an Excel workbook as pictures
The methods we've just discussed will come in handy when dealing with a small number of diagrams. But what if you need to copy all charts from an Excel workbook? Copying and pasting each one individually can be quite time consuming. I hasten to please you - you won't have to do this! There is a way to save all charts from an Excel workbook at once.
To the selected folder along with the files .html all charts contained in the Excel workbook as files will be copied .png... The screenshot below shows the contents of the folder where I saved my workbook. My Excel workbook consists of three sheets with a diagram on each - and in the folder I selected we see three diagrams saved as graphic files .png.
As you know, PNG is one of the best formats compression of images in which there is no loss of quality. If you prefer to use other formats for pictures, then convert them to .jpg, .gif, .bmp or any other will not be difficult.
Save the diagram as a picture using a VBA macro
If you need to export Excel charts as pictures often appear, then you can automate this task using VBA macro... Fortunately, there are many such macros already written, so we don't have to reinvent the wheel.
For example, you can use the tested and reliable solution posted by John Peltier on his blog. Its macro is very simple:
ActiveChart.Export "D: \ My Charts \ SpecialChart.png"
This line of code creates a graphic file in the given folder .png and exports the chart to it. You can create your first macro right now in 4 simple steps, even if you have never done it in your life.
Before you start writing a macro, prepare a folder for exporting a diagram. In our case, this will be the folder My charts on disk D... So, all the preparations are complete, let's get started with the macro.
Comment: If you are creating a macro for the first time, then, most likely, the tab Developer(Developer) will be hidden. In this case, go to the tab File(File), click Parameters(Options) and open the section Customize Ribbon(Customize Ribbon). On the right side of the window, in the list Main tabs(Main Tabs) check the box next to Developer(Developer) and click OK.
Now let's run the macro we just created to see how it works. Wait a minute ... There's something else we have to do. We need to select the Excel chart that we will export, since our macro only works with the selected chart. Click anywhere on the edge of the diagram. A light gray box that appears around the chart will signal that it is fully selected.
Open the tab again Developer(Developer) and click the icon Macros(Macros). A list of macros available in your workbook... Highlight SaveSelectedChartAsImage and press the button Execute(Run).
Now open the folder that you specified to save the file - there should be a picture there .png with exported chart. You can save diagrams in a different format in the same way. To do this, it is enough to change in the macro .png on the .jpg or .gif- like this:
ActiveChart.Export "D: \ My Charts \ SpecialChart.jpg"
That's all for today, and, I hope, reading this article, you have spent your time with benefit. Thank you for attention!
Shown below are two easy ways extracting images from XLS, XLSX file ov. The first method does not require any software, since it is based on the use of built-in MS Excel capabilities. For the second method, we used software Image Extraction Wizard... Both of these options are pretty simple and shouldn't take long.
Extract images from Excel files using MS Excel capabilities
This method is very simple as it does not require any additional software. To batch extract all images from Excel files, follow these steps:
- Step 1: First of all, open the file in MS Excel. You can open both XLS and XLSX files. Then select the command Save as in the tab File.
- Step 2: In the window Save as in the dropdown menu File type you should choose an option Webpage to save the file as a web page.
Extract images from Excel files with Office Image Extraction Wizard
It is free software that allows you to easily extract batch images from Excel files. It not only extracts images from Excel file but from most Office files such as DOC, PPT, PPS, DOCX, PPSM, PPSX, XPS, SWF, etc.
To extract images from a file Excel data method, you will first need to download and install the software. Then you need to run the program and download Excel file and assign the output folder. After that, you just need to press Next and you get the result. All images from the file are automatically saved in the specified folder.
The software also has a Batch Mode that can be used to extract images from more than one file at a time.
You can choose any of these methods of image extraction, as both methods are equally capable of being quite simple and convenient.
Leave your comment!
Very often, in a working document, a user may be faced with the need to insert a picture or, conversely, save it to his computer. For example, you received a price list or a catalog, and the illustrations contained in it are necessary for you to fill your online store. It may seem that everything is pretty easy, however, many face problems when trying to get them out of an Excel document. Let's find out what steps you need to take to insert or pull an image from Excel quickly and easily.
You can add or download pictures to Excel regular means editor
Insert a photo or picture
To place the picture on the sheet, go to the "Insert" tab, there you will find the "Illustrations" area. Select the cell where you want to insert it, click on the "Picture" or "Picture" button and select the required image in the menu that appears. By default, the "Pictures" folder opens, in which, as a rule, all files downloaded from the Internet are saved. If the required image is in a different place, after going to the "Picture" menu, pay attention to the window that appears on the left. This is the root structure of all media and folders on your computer. Thanks to her, you can find exactly the folder in which you saved the drawing.
An open image can be subjected to all sorts of changes, for example, enlargement, reduction or rotation. By clicking on the picture, and thus selecting it, you will notice that it will be enclosed in a frame with circles and squares. By dragging them, you will increase or decrease the size of the picture, and the green circle on top will allow you to expand it as you like. Also, the picture can be subjected to more serious settings by selecting and right-clicking, and in the appeared context menu select the item "Size and position". In the window that appears, information about the original size of the image is provided; it is possible to set the exact parameters of height, width and rotation. If you want to keep the aspect ratio of the image, check the boxes next to "Maintain aspect ratio" and "Relatively original size". These settings are mainly intended for changing the size and shape, however, you can also change the drawing itself, giving it, for example, a specific shade or, in general, recolor it. Having selected it, at the very bottom you will see the item "Picture Format". Here you have access to the functions of shading the image, setting its color and angle of incidence. In addition, you can customize its reflection by adjusting the side where it will be reflected, size, transparency, distance, etc. In fact, there are many different parameters, adjusting which can ultimately change the image beyond recognition.
Save picture, photo, etc.
So, we figured out how you can copy a picture and paste it into a document, and besides that, we figured out where and what changes can be made to it. However, sometimes the question arises of how to "stretch" or save the images that are located in the document downloaded from the Internet Excel format? There are several options.
- Save the document in web page format, i.e. html. Select "Menu", and there "Save as". Select a web page from the drop-down list under "Files of type". There are several of them and you can choose any. Go to the directory where your document was saved and open it with a browser. In it you will see the text itself and all the images that will be easy to download by simply right-clicking on them and selecting the "Save Image As" command. The name of the command itself may vary depending on the browser installed.
- If the image initially has good resolution and quality, you can stretch it, copy it using the keyboard shortcut "Ctrl + C" and then open standard program Paint and paste. Then we save and get the file in PNG format.
- In addition to the above simple operations, popularity Excel programs provided her additional software, which is designed to solve a variety of specific and specific tasks... It is for this purpose that an add-on called PastePictures was created. Thanks to her, the program searches for pictures in the specified folder, based on the contents of the table cells, and then inserts them into adjacent cells or notes to them. In addition, its functionality allows you to download images from links and save them to specific folders, and then insert them into cell notes. After downloading the add-in and opening it, you will be given the opportunity of a test run, during which you will see its main features using a specially created document as an example, where pictures will then be added and the table format changed. In addition, it has many other options that will allow you to conveniently work on tables, insert and save images. The process of inserting pictures into a document was described above. To save them, select the installed add-on and in the left upper corner click on the command "Pictures". In it you will see the item "Save pictures from the sheet to files", thanks to which you will transfer the images to the memory of your computer. You can download the add-on by following this link - http://excelvba.ru/programmes/PastePictures.
The above steps will help you solve the problem of saving and pasting a variety of images in Excel documents, and some of them are also applicable in Word.
PDF - was developed as a format for presenting books and magazines on computers. In everyday life and business, it is most often used to create, so to speak, immutable documents. For example, you have created a table with tariffs or an agreement and you need to send it to the client - so that the client does not change anything there, it is best to save it in PDF. After all, Excel can be easily, even if you protect it with a password.
XML- was developed as a language convenient for processing documents by programs and convenient and understandable for working with a document by a person. You can say the format is specially created for the Internet. Very often through such universal language there are exchanges between the two programs. For example, automatic unloading from Access and loading into 1C.
Full list available formats shown in the picture:
As shown earlier, for save Excel in PDF, you need to go to the menu, select Save as - then the item PDF or XPS (in the first picture).
XPS is also special format to protect the content of the document, you can say an electronic sheet of paper.
Excel to JPEG or PNG
There is no picture for the format special function save, but it's pretty easy to do it using Windows tools.
First of all, almost every keyboard has special button Print screen(screenshot), it is located to the right of F12. Most often something like PrtScn or Prt Sc is written on it.
After clicking this button, the picture with the screen image is saved and you can paste it anywhere: in a letter, in Word or in Paint program... From Paint already can be saved in both JPEG and PNG.
If you only need to copy active window press Alt + PrtScn - described in more detail.
It's even easier to find the scissors program (starting in Windows 7 it is built-in). Start - all programs - Standard there are these same scissors - now you can select any fragment and immediately save it to the desired format picture. Convenient - I recommend it to those who do not use it.
If you have a MAC - for a screenshot, press Shift + Command + 3
Save Excel to XML
Again, as shown in the big picture, left-click on Save As - then a save window will open in the File type box, looking for XML data (* .xml).
Share our article on your social networks:If an error appears while saving, save in the format XML table 2003 is also on the list. Most often this happens because XML document may not accept more than 65 thousand lines, and the 2003 format truncates them!
