Adjust Chart Settlement For Free

On the Format tab, in the Current Selection group, click Format Selection. In the Format Chart Title dialog box, click the Alignment category. Under Text Layout, do one of the following: To align text, in the Vertical alignment box, click the option that you want.

Then go to the Current Selection group, and select Chart Area by clicking the drop down arrow. See screenshot: 3. Move mouse to one of the corners of the chart or to the midpoints of chart borders until the mouse changes to a double headed white arrow, then you can drag the Chart Area to the size you want.

Resizing a chart Charts can be resizedmade larger or smallerto fit on a worksheet. Chart titles are sized in proportion to how large or small you make the chart. And within the chart area, the legend and/or plot area can be made larger or smaller. Chart titles can be moved but not resized.

Excel: Move a ChartSelect the data. Press Alt+F1.The chart is already selected. Ctrl+x to cut.Ctrl+Home to move to the top.Select the cell where you want the top-left corner of the chart.Ctrl+v to paste in A1. You can then use the mouse to drag the border of the chart to the right place.

Move bars closer together in an Excel bar chartRight-click on the data series and select Format Data Series from the context menu.Then in the Format Data Series pane, change the data in Gap Width to resize the gaps between the bars, the smaller the data is the much loser the bars together.More items...

Resize a chartTo 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.More items...

To move a chart in Excel within a worksheet, click and drag inside the Chart Area of the chart. The mouse pointer appears as a four-pointed arrow while you click and drag to move the chart. When the chart is in the desired location, release the mouse button to drop the chart into its new worksheet location.