Editing and Formatting Chart Elements
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.
Note
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. ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
