Excel Tip of the Day
Changing Excel's default chart type (97/2000/2001/2002)
By default, Excel initially tries to plot data using a Clustered Column chart format. However, you may prefer that data is plotted as a line chart by default. Fortunately, Excel allows you to change its default chart type. To do so, select some valid data and launch the Chart Wizard as you normally would. Then, select the chart type you prefer to use and finish setting up your chart. Next, select the chart and choose Chart | Chart Type from the menu bar. When the Chart Type dialog box appears, click the Set As Default Chart button.
What happens next depends on what formatting you've applied to the chart. If your chart conforms to one of Excel's existing standard chart types, you'll simply need to confirm that you want to use it as the default. If your chart has been highly-customized, you'll still be asked to confirm that it should be the default. However, you'll also need to specify a name for your new chart type.
To restore the original Clustered Column type as the default, you can follow the above steps to set it as the default. As an alternative, display the Chart Type dialog box and click on the Custom Types tab. Then, select the User-Defined option button. Simply select the Default choice in the Chart Type list box and click Delete. You'll then be prompted to delete the type you specified and restore Excel's original default type.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.