how to select info and make a pie chart in excel pc

#HOW TO SELECT INFO AND MAKE A PIE CHART IN EXCEL PC PDF#
#HOW TO SELECT INFO AND MAKE A PIE CHART IN EXCEL PC UPDATE#
#HOW TO SELECT INFO AND MAKE A PIE CHART IN EXCEL PC PRO#

#HOW TO SELECT INFO AND MAKE A PIE CHART IN EXCEL PC PRO#

To conduct these tests, I used a graph on my Macbook Pro and my Asus (PC) laptop for testing, both running Office 365. This approach does work, but I think the Preview option gives a slightly higher resolution. From this menu, you can save the image as a PNG, GIF, BMP, PDF, or JPG.

#HOW TO SELECT INFO AND MAKE A PIE CHART IN EXCEL PC UPDATE#

UPDATE (): Francis Gagnon pointed out that Mac users can simply right-click on the image in Excel and select the Save As Picture option.

Of all the methods I tested, this provided the highest quality image. In the save window, you can change the DPI to 300 pixels (or whatever you like). In Preview, select Save and change the file format to PNG. This will load the copied graph from Excel directly into Preview. On Macs, the user can copy the graph from Excel ( CMD+C), open the Preview tool and create a new document ( CMD+N). I tested a few options here, but image quality wasn’t sufficiently high enough to warrant the multiple steps necessary to create the image. Because they are vector images, PDFs tend to have the best resolution, but to get a standalone image you still need to export it from Adobe as an image file.

#HOW TO SELECT INFO AND MAKE A PIE CHART IN EXCEL PC PDF#

Save the graph (made in either Excel or PowerPoint) as a PDF file (through the SaveAs or Print menus), crop in Adobe, and then save as an image. I’ve tested that approach and the quality of the final images is still not that high, likely because the image resolution still depends on the resolution of the screen. It is possible to build an image exporting engine in Excel ( like this one from Jon Peltier) using VBA code (on PCs only). (Only the first method works on Macs though). I find that this second method creates more higher-quality images. Second, right-click on the graph and SaveAs a Picture.

On PCs, there are two ways to get the slide/image out of PowerPoint: First, use the standard SaveAs command. If the user wants the Excel graph to be a specific size, then the PPT slide could be set at those dimensions.

Copy the graph from Excel, paste into PowerPoint, and export. I did not test third-party tools like Camtasia or Screencast-o-matic in this exercise, but consistent image sizes will be an issue whenever you need to manually select the area of the screen to capture. The other big problem with screenshots is that image size may vary depending on exactly where the user places their cursor. Mac screenshots are going to be better than those taken on PCs because of the inherent better resolution of Mac screens. I can summarize these methods into five main categories:

I think there is a better way to obtain high-quality images out of Excel and have tested a number of different ways to do so. Future Directions for the Demography of Aging Source: Example of a blurry set of images. The screenshot solution doesn’t always work because the quality of the screenshot depends on the resolution of the monitor. Many people create standalone graphs by taking screenshots of their Excel window, but screenshots can look blurry and pixelated, especially next to text that surrounds it. As you probably know, Excel does not have a native image-exporting feature, so it requires a separate process to create a high resolution, standalone Excel chart.

How to select info and make a pie chart in excel pc