Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Save Excel Chart as Image? 4 Simple Ways

How to Save Excel Chart as Image? 4 Simple Ways

(Note: This guide on how to save Excel chart as image is suitable for all Excel versions including Office 365)

There are a variety of ways you can represent the data in Excel. Representing data using pictorial representations like graphs and charts greatly improves the readability of the data and helps the user understand them in a better way. Depending on the type of data and your audience, you can choose from a variety of ways to represent the data.

When you insert the data and create a chart, that particular chart is limited only to the Excel file. If you want to refer to the chart or share it, you will have to send the whole Excel file.

In case you want to add the particular chart to a presentation or download the graph/chart for future references, you will need to save the Excel chart as an image.

In this article, I will tell you how to save Excel chart as image in 4 easy ways using an example.

You’ll Learn:

  • Example
  • How to Save Excel Chart as Image?
    • Using the Save As Picture Option
    • Copy and Paste the Excel Chart
    • By Taking a Screenshot
    • Save Multiple Charts Together

Related Reads:

How to Save Excel as PDF? 5 Useful Ways

How to Create Excel Drop Down List With Color?

How to Copy Only Visible Cells in Excel? 3 Easy Ways

Example 

Consider an example where an Excel sheet contains the data of a certain company. The tables give the profit percentage of the said company for a period of 10 years (2010-2020). For the representation of data, you might need to depict the data in the form of graphs or charts.

In this case, using a clustered column or a scatter plot will be the most suited choice of the chart to depict the data. Create a chart by selecting the data and navigating to the Insert main menu. Click on the chart. 

Let us choose the Scatter Plot to depict the data. The chart appears in the center of the sheet.

Example
Example

Now that we have a chart, let us see how to save the Excel chart as an image. You can save the chart as an image in the form of .jpg, .png, or .bmp.

How to Save Excel Chart as Image?

Using the Save As Picture Option

This is the easiest way to save Excel chart as image.

  • Once you have populated the chart, right-click on the chart.
  • Select Save As Picture.
Save Excel Chart as Image using Save As Picture
Save Excel Chart as Image using Save As Picture
  • Once you click on this option, a new dialog box opens. 
  • Choose the file location and file name where you want to save the data. Also, from the drop-down choose the file format of the image.
  • Click on Save.
  • This saves the Excel chart as an image in your local storage. Navigate to the file location and open and see the image.
Save the Chart
Save the Chart

This method gives you clear images irrespective of the size of the chart in the Excel sheet. 

Copy and Paste the Excel Chart

This is one of the traditional means to save any image. This method is mainly used when you have to attach an image to a mail, a Word document, or any other platform. 

One advantage of this method is that you can just copy and paste the image onto other platforms and even save them as an image if needed.

  • Click on the chart.
  • Then, right-click on the chart and click on Copy. Or, use the keyboard shortcut Ctrl+C to copy the chart.
Copy the Excel Chart
Copy the Excel Chart

You can do this if you want to paste the image into any other platform such as PowerPoint or Word. Just open the desired application, right-click where you want to insert the image, and paste it as a Picture.

Paste the Excel chart as Picture
Paste the Excel chart as Picture

In case you want to save the Excel chart as an image, open any image creator/editor app. By default, Windows Paint is the most suitable one for this purpose. 

  • Open Paint.
  • Right-click and paste the copied chart or press Ctrl+V.
Paste into Paint
Paste into Paint
  • Now, click on Save or press Ctrl+S.
  • Choose the file location and rename the image. From the Save As type dropdown, choose the format you want to save the image. Click Save.
Enter the file name and location
Enter the file name and location
  • This saves the image in the specified location. Navigate to the location and click on the image to view it. You can also copy or edit the image.
View the image
View the image

Customize the Dimensions of the Image

When you insert a chart, the chart tends to populate the center of the Excel sheet with default dimensions. If you copy, paste, and save the chart as an image with the same dimensions, the resolution will be less (as seen from the above image).

In some cases, the image might not be very clear to portray each data point and transition. In such cases, you can extend and resize the chart by using the anchor points in the Excel sheet. You can then copy and paste the chart into Paint and save the Excel chart as an image.

Customize and save the chart
Customize and save the chart

When you paste the file onto the Paint canvas, the dimensions of the canvas automatically change to fit the image. If you want white spaces around the image to add text or arrows, you can extend the canvas and then save the image. 

Also Reads:

How to Convert Formulas to Values in Excel? 6 Easy Methods

How to Convert XML to Excel? – 2 Easy Methods

How to Enable Excel Dark Mode? 2 Easy Methods

By Taking a Screenshot

Another way to save Excel chart as an image is to take a screenshot of the chart and crop them as you wish. This would be helpful in several places, where you might have to showcase the chart along with the data, but without attaching the file.

  • To take a screenshot and crop it, first, open the Excel worksheet with the chart.
  • Open the Snipping Tool application. You can find it in the start menu. 
  • Click on the New icon to create a new snip. 
  • Using the left mouse button, drag and select the region you want to convert as an image.
  • Once you leave the mouse button, the selected region shows up in a new window. You can edit the image and then save the image.
Save Excel Chart as Image by taking a screenshot
Save Excel Chart as Image by taking a screenshot

Save Multiple Charts Together

In some cases, your Excel sheet might have more than one chart which depicts information. Although you can use the above methods to save Excel charts as images, saving each image one after the other might be a bit challenging. 

Save Multiple Excel charts as images
Save Multiple Excel charts as images

In such cases, you can save all the charts as images at the same time.

  • Navigate to File and click on Save As.
  • In the Save As pane, choose the file location and rename the image. In the file type dropdown, click on Web Page( *.htm, *.html). 
  • Click on Save.
Save as web page
Save as web page
  • Now, navigate to the saved file location and open the folder. You will find all the charts saved as images.
Open the folder and view the images
Open the folder and view the images

Note: Apply any changes you make to the image when you save them using the Chart Design or Format option. So, make sure you make all the necessary changes to the chart and then save them.

Suggested Reads:

How to Use Nested VLOOKUP in Excel? A Step-by-Step Guide

How to Fix the #REF Error in Excel? 3 Easy Methods

How to Hide and Unhide Columns in Excel? (3 Easy Steps)

Frequently Asked Questions

How do I save the Excel chart as a high-resolution image?

The best way to get a high-resolution image of the chart is to select the Save As Picture option when you right-click the chart. You can also save the Excel sheet as a web page and then use the images from the folders.

How do I change the format of the image?

When you save an Excel chart as an image, in the Save As dialog box, you will find a dropdown to change the type of the image. You can choose any of the image types from the dropdown and click on Save.

How to edit the Excel chart before saving them as an image?

If you want to add customization to the chart, it is better to use the Chart Design and Format options to do that. You can edit the image, add text and markings while taking a screenshot, and copy and paste them onto Paint.  

Closing Thoughts

Converting graphs and charts into images greatly increases the usability of the statistics across different platforms and helps for any future references. 

In this article, we saw how to save Excel chart as image in 4 easy ways along with an example. Depending on your usage, you can either choose to save the image from the Save As option, take a screenshot, or save multiple charts together. Each method has its advantages and functionalities. Choose the method that suits you the best.

Please visit our free resources center for more high-quality guides on Excel and other Microsoft Suite applications.

Ready to dive deep into Excel? Click here for advanced Excel courses with in-depth training modules.

Simon Sez IT has been teaching Excel and other business software for over ten years. For a low, monthly fee you can get access to 140+ IT training courses. 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Group Worksheets in Excel? (In 3 Simple Steps)

How to Assign a Fixed Cost to a Task in Microsoft Project 2016?

Reconcile Bank Accounts in Quickbooks 2019

Managing Microsoft Outlook 2010 with Mailbox Rules

How to Setup Calendar Options in Outlook 2013

How to Create a Timeline in PowerPoint? 2 Proven Methods

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)