Adjust Chart Notice For Free

Click the chart, and then drag the sizing handles to the size that you want. Click the chart, and then on the Format tab, under Size, enter the size in the Height and Width boxes.

Edit the contents of a title or data label that is linked to data on the worksheetIn the worksheet, click the cell that contains the title or data label text that you want to change.Edit the existing contents, or type the new text or value, and then press ENTER. The changes you made automatically appear on the chart.

For example, if you wanted to select every label in a series, then left-click on one of the labels and press CTRL+A. All of the labels in that series will be highlighted. As a bonus, you can continue pressing CTRL+A to select all of the labels in all series, and CTRL+A again to select all labels in the chart.

On the Format tab, in the Current Selection group, click Format Selection. In the Format Axis dialog box, click Alignment. Under Text layout, do one or more of the following: In the Vertical alignment box, click the vertical alignment position that you want.

Change the position of data labels (Office 2010)On a chart, do one of the following: To reposition all data labels for a whole data series, click a data label one time to select the data series.On the Layout tab, in the Labels group, click Data Labels, and then click the option that you want.

Right-click the category labels you want to change, and click Select Data.In the Horizontal (Category) Axis Labels box, click Edit.In the Axis label range box, enter the labels you want to use, separated by commas.

To format data labels in Excel, choose the set of data labels to format. To do this, click the Format tab within the Chart Tools contextual tab in the Ribbon. Then select the data labels to format from the Chart Elements drop-down in the Current Selection button group.