Although the default chart settings are often good enough to get you started, Excel offers a broad range of chart options that give you complete control over the look of the chart and plot area. The easiest way to change many chart options is to rerun the Chart Wizard. The wizard's dialog boxes pick up your current chart settings and let you change chart types, edit the source data, apply new formatting, or change the location of your chart.
All the techniques described in this section work equally well with embedded chart objects, chart sheets, and PivotCharts.
To adjust individual chart objects, first select the object (the chart title or the category axis, for example), and then change its properties. ...