4.4.3 Charts

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

Create a Chart

To create a line chart, execute the following steps.

1. Select the range A1:C6.

2. On the Insert tab, in the Charts group, choose Line, and select Line with Markers.

excel1

 

Result:

excel2

Change Chart Type

You can easily change to a different type of chart at any time.

1. Select the chart.

2. On the Insert tab, in the Charts group, choose Column, and select Clustered Column.

excel3

Result:

excel4

Switch Row/Column

If you want the animals, displayed on the vertical axis, to be displayed on the horizontal 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.

switch-row-column

Result:

excel5

 

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.

add-chart-title

3. Enter a title. For example, Population.

Result:

excel6