Adjust Chart Document For Free

Click anywhere in the chart that contains the data series that you want to plot on different axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Switch Row/Column.

Resizing a chartCharts 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.

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.

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.

The easiest way to select the chart area is to click just below the top edge of the chart. The Chart Elements menu on the Format tab of the ribbon, and the Format Task pane title will confirm the chart area is selected. Once the chart area is selected, you can make a variety of formatting changes.

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.

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...