Manually change the layout of an Excel 2007 chart element

Click the Excel 2007 chart, or select the chart element for which you want to change the layout.

How to select a chart element from a list of chart elements

Click the chart to display the chart tools.

On the Format tab, in the current selection group, click the arrow next to the Chart elements box, and then select the chart element that you want.

Tip This displays the chart tool and adds the design, layout, and Format tabs.

On the Layout tab, perform one or more of the following actions:

In the tags group, click the Label layout option that you want.

In the Axes group, click the axis or gridline option that you want.

In the background group, click the layout options that you want.

Note The layout options you select Apply to the element that is already selected. For example, if the entire chart is selected, the data labels are applied to all data series. If a single data point is selected, the data label is applied only to the selected data series or data points.