Charts

Create a Chart | Switch Row/Column | Add Chart Title | Change Legend Position | Change Chart Type

A simple Excel chart can say more than a sheet full of numbers. As you'll see, creating charts is very easy.

Create a Chart

To create a chart, execute the following steps.

1. Select the data range you want to include in the chart. Include the headers.

2. On the Insert tab, click Column and select one of the subtypes. For example, Clustered Column.

Result:

Switch Row/Column

If you want the departments, displayed on the vertical (value) axis, to be displayed on the horizontal (category) axis instead, execute the following steps.

1. Select the chart. The Chart Tools contextual tab activates.

2. On the Design tab, click Switch Row/Column.

Result:

Add Chart Title

To add a chart title, execute the following steps.

1. Select the chart. The Chart Tools contextual tab activates.

2. On the Layout tab, click Chart Title, Above Chart.

3. Enter a title. For example, Profits.

Result:

Change Legend Position

By default, the legend appears to the right of the chart. To move the legend to the bottom of the chart, execute the following steps.

1. Select the chart. The Chart Tools contextual tab activates.

2. On the Layout tab, click Legend, Show Legend at Bottom.

Result:

Change Chart Type

You can easily change to a different type of chart at any time. Execute the following steps to achieve this.

1. Select the chart. The Chart Tools contextual tab activates.

2. On the Design tab, click Change Chart Type.

3. For example, choose Bar and select Stacked Bar as subtype.

Result:

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Charts    |    Go to Next Topic: Pivot Tables