Save as picture not always available in Excel

Dave Denz 0 Reputation points
2023-10-17T16:21:30.5466667+00:00

Several charts (graphs) have been created in Excel, when right clicking on some, the option to "Save as picture" appears and, when clicked, saves a high resolution .png (1664 x 1081) file. The option however, appears for some but not all charts. All charts are on the same spreadsheet and all were created from the same data in the same way.

Any thoughts as to how to get "Save as picture" to appear when clicking on every chart?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 20,500 Reputation points
    2023-10-17T16:38:50.08+00:00

    Certain chart types in Excel, such as PivotCharts, 3D charts, and specific specialized charts, may not support the "Save as picture" feature. Additional elements, like text boxes, shapes, or other objects, can affect the "Save as picture" feature.


  2. Dave Denz 0 Reputation points
    2023-10-17T16:47:02.4566667+00:00

    The answer provided was deficient in several areas: 1) saving a chart into either Paint or a .pdf provides only a low-resolution image. "Save as picture" (when available) produces a high-resolution image - needed. 2) answer indicates that a difference in the complexity of graphs may make some too complicated to convert. All charts are simple compound bar/line charts with 5 bars and 2 lines. 3) it appears some have had the same problem when switching from a laptop to a desktop. Not the case here. Same computer and program used for all.

    It's hard to believe this is a unique issue in 2023. Would appreciate anyone's help.

    0 comments No comments