Adjust Chart Charter 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, in the Size group, enter the size in the Shape Height and Shape Width boxes.

Right-click on the axis and select "Format Axis" from the drop-down menu. In the "Format Axis" pane that appears on the right-hand side of the screen, select the "Axis Options" tab. Under "Bounds," you can manually set the minimum and maximum values for the axis scale. Click "Close" to apply the changes.

Edit or rearrange a series Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK. Changes you make may break links to the source data on the worksheet.

To resize a chart, do one of the following: To change the size manually, click the chart, and then drag the sizing handles to the size that you want. To use specific height and width measurements, on the Format tab, in the Size group, enter the size in the Height and Width box. .

Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Layouts group, click the chart layout that you want to use.

Under Chart Tools, on the Design tab, in the Data group, click Edit Data. Microsoft Excel opens in a new window and displays the worksheet for the selected chart. In the Excel worksheet, click the cell that contains the title or the data that you want to change, and then enter the new information. Close the Excel file.

Tips for arranging data for charts Select specific cells, columns, or rows for your data. For example, if your data has multiple columns but you want a pie chart, select the column containing your labels, and just one column of data. Switch the rows and columns in the chart after you create it. Select the chart.