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 chart template. 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 a chart template, follow these steps if you are using Excel 2007 or Excel 2010: • Use whatever formatting commands are necessary to define your chart just the way you want it. • Display the Design tab of the ribbon. (This is visible only when the chart is selected.) • Click Save As Template. Excel displays the Save Chart Template dialog box. • In the File Name box enter the name under which you want this template saved. • Click on Save. These steps won't work if you are using Excel 2013. The reason is simple: The Save As Template tool has been removed from the Design tab of the ribbon. All is not lost, however. Follow these steps, instead: • Use whatever formatting commands are necessary to define your chart just the way you want it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2018
Categories |