Excel Course: Inserting Graphs

We will be using the following table throughout this lesson (you can download it by clicking here).

select table data - excel inserting graphs

Select the table and choose a graph in the "Insert" tab.

choose graph - excel inserting graphs

The graph will be inserted onto the sheet.

insert graph - excel inserting graphs

Whenever the graph is selected, additional tabs will be displayed.

To change the type of graph (if needed), click on "Change Chart Type".

edit graph type - excel inserting graphs

And choose a new type.

line graph - excel inserting graphs

You can choose one of the predefined layouts.

choose layout - excel inserting graphs

Or one of the predefined styles.

graph styles - excel inserting graphs

From the "Layout" tab, you can add/remove/customize the following elements : titles, legends, labels, data tables, axis, gridlines, border, etc.

graph title - excel inserting graphs

You can also customize these elements separately (by selecting them on the graph).

select element - excel inserting graphs

For example :

format element - excel inserting graphs

The "Format" tab for graphs is very similar to the "Format" tab that we have already discussed.

format graph ground - excel inserting graphs example - excel inserting graphs

Changing a Graph's Data Source

To change the data range used to draw the graph, click on "Select Data Source...".

select data source - excel inserting graphs

Then simply edit the range (by selecting it on the sheet).

display - excel inserting graphs