Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Understanding Custom Chart Templates.
There may be times when the built-in chart formats just don't meet your needs. In these instances, you can always make any changes desired to your chart and then save all the chart settings as a user-defined format. You can then apply these settings to other charts, and you won't have to go through the long or tedious steps necessary to do all the formatting over again.
To create your own chart format, follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3211) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Understanding Custom Chart Templates.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Need to export a graphics group from a chart so that you can use the group in a different program? It's not as easy as ...
Discover MoreGraphics can really add pizzazz to a worksheet, but they can also present some drawbacks. If you want to get rid of all ...
Discover MoreDo you need to add a logo or other graphic to a bunch of worksheets? Here are a couple of short macros that can make ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-08-14 13:53:37
Julie
I have a detailed income/expense spreadsheet for homesteading. I want to do a column chart that will show income / expense / difference totals only in each category for the year (Farmers Market, Fowl, Cows, Greenhouse, etc.). I have Excel 2013, and cannot find 'Custom Types' on the Chart menu. I am very new to charts in Excel, so please let me know if it can be done. Thank you!
2015-04-02 19:15:13
Rachele
Thank you. I have saved my template however, my orientation keeps changing. Any tip? Not an issue for a few charts but I'm doing 40 :-)
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 © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: 
Comments