Applying Settings to Multiple Charts

If you would like to apply the current settings to other charts in the model, you can select which settings to apply and where to apply them. (These instructions apply anywhere the Apply To button is displayed.) Apply To settings are both flexible and powerful. They can be used as focused or broad defaults.

  To specify how chart settings should be applied:

  1. Click the Apply To button.

  2. In the Apply To dialog, indicate the tab or tabs of settings to apply:

    • This Tab applies only settings on the current tab.

    • All Tabs applies all the current settings in the entire dialog.

  3. Indicate where the settings should be applied.

    • This Sheet applies the settings to only the current sheet of the current workbook.

    • This Workbook applies the settings to all sheets of the current workbook.

    • All Open And New Workbooks applies the settings to all workbooks that are currently open and all workbooks to be created.

      All Open and New Workbooks effectively changes the global Chart Preferences defaults to the settings on the current tab or all tabs, depending on the setting in the previous dialog group.