Spread Out Chart Form For Free

Chart Columns Right-click on a set of columns in a chart and select "Format Data Series." Move the "Gap Width" slider to the right to increase the space between columns. Move the "Series Overlap" slider to the left to add space between individual columns displayed together in a clustered column format.

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.

Right-click inside the cell you want to change, and click Format Cells. On the Alignment tab, change Vertical to Top, Center, or Bottom, depending on where you want your text to be placed inside the cell. Click OK. Your text is now aligned and evenly spaced where you wanted it.

Follow along; it's easy. Right-click on any of the colored bars. In the drop-down menu, select Format Data Series. Reduce the Gap Width. Gap Width is a jargony name that simply refers to the size of the spacing or gap in between the columns. Excel's default setting is typically around 150%.

Right-click the chart, and then choose Select Data. The Select Data Source dialog box appears on the worksheet that contains the source data for the chart. Leaving the dialog box open, click in the worksheet, and then click and drag to select all the data you want to use for the chart, including the new data series.

Click anywhere in the chart or click the chart element that you want to change. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, do the one or more of the following: In the Labels group, click a layout option for the chart label that you want to change.