To make your charts appear the way you want, you may need to change the settings in the Chart pane in the Excel Preferences dialog box. The Chart pane contains some settings that affect only the selected chart and other settings that affect all charts.
To open the Chart pane, follow these steps:
Preferencesor press Cmd+, (Cmd and the comma key) to display the Excel Preferences dialog box.
Figure 7–15. In the Chart pane of ...