Working with Charts
Now that you know how to create a chart in Excel, you're ready to discover how you can customize and modify your charts. Excel lets you control most of the chart's elements, including the axes, chart text, and series patterns and colors.
The Chart toolbar is very useful for making changes to charts. When working with charts, you frequently add data labels to a chart to further describe the data in each data series. You decide on the elements of your chart, such as whether to show or hide a legend and gridlines, select a different chart type to fit your needs, and re-order a chart's data series.
Before you can change anything on a chart, you must select the chart. Click anywhere on the chart. You should see selection handles ...