Monday, March 27, 2017

Save a chart as a picture in Excel for Windows

Save a chart as a picture in Excel for Windows

You can quickly copy your chart to another program by saving it as a picture. This also prevents people from editing your chart.

  1. Click the chart you want to save as a picture.

  2. On the Home tab > Copy.

  3. On the Home tab, click the arrow under Paste, > Paste Special.

    Art showing Paste Special Options found by clicking the arrow under Paste on the Home tab
    Paste Special in PowerPoint, which is the same for Word and Excel.
  4. In the Paste Special box, in the As list, click the graphic file format that you want.

    Top part of Paste Special dialog box
  5. Right-click the graphic, > Save as Picture.

  6. Type a name for your graphic file, browse to the location to save the file, and > Save.

Tips:  In PowerPoint, you can right-click the chart and > Save as Picture. There's no need to copy it as a picture first.

Chart with right-click shortcut menu open and Save as Picture command highlighted

Help me pick a graphics file format

File format

What it means

Device Independent Bitmap (.bmp)

Graphics created in one program are displayed in another program exactly the way they appeared in the original program.

Graphics Interchange Format (.gif)

Supports 256 colors and no image data is lost when the file is compressed.

JPEG File Interchange Format (.jpg)

Best used for pictures with many colors, such as scanned photos.

Portable Network Graphics Format (.png)

Improves the quality of graphics on a web site because parts of the image can be transparent and brightness can be controlled.

No comments:

Post a Comment