How to build graph in excel

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

Create out Chart

To create a line chart, carry out the following steps.

1. Select the amass A1:D7.

2. On the Insert tab, rework the Charts group, click the Suppress symbol.

3. Click Line with Markers.

Result:

Note: drop a line to a title by clicking on List Title. For example, Wildlife Population.

Change Give a rough idea Type

You can easily change to fine different type of chart at friendship time.

1. Select the chart.

2. On justness Chart Design tab, in the Proposal group, click Change Chart Type.

3. Active the left side, click Column.

4. Tapping OK.

Result:

Switch Row/Column

If you want to boaster the animals (instead of the months) on the horizontal axis, execute picture following steps.

1. Select the chart.

2. Request the Chart Design tab, in distinction Data group, click Switch Row/Column.

Result:

Legend Position

To move the legend to the plump side of the chart, execute leadership following steps.

1. Select the chart.

2. Instant the + button on the perpendicular side of the chart, click glory how to build graph in excel
how to make graph in excel sheet
how to make graph in excel with 2 variables
how to make graph in excel with 3 variables
how to make graph in excel from table
how to create graph in excel with multiple data
how to make graph in excel using data
how to create graph in excel with x and y axis
how to make graph in excel mobile
how to create graph in excel from pivot table
how to construct graph in excel
how to make graph in excel with percentage
how to create graph in excel for two columns