Written by Allen Wyatt (last updated May 22, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
It is not unusual to spend a good amount of time to get your Excel charts looking just the way you want them too. After putting in the time for the desired result, you may want to export a graphics group as a single GIF file so you can use it in other programs or on the Web.
Unfortunately, there is no way to do this in Excel. Even in VBA the group cannot be exported as a graphic. (Individual objects can, but not the group as a whole.) The only workaround that we could come up with seems rather old-fashioned. Follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1974) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Adding a trendline to a graph will allow you to see trends a bit easier, depending on your data. You can even utilize an ...
Discover MoreIf you need to arrange a group of graphics so that they are evenly distributed between a starting point and an ending ...
Discover MoreExcel allows you to create all sorts of drawings using a wide assortment of tools. When you need to take an action upon ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-11-14 05:52:36
Richard
Just wondering if the Shift + Edit > Copy Picture would be more elegant.
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments