A more recent version of the Excel course is available here: Excel Course

Excel Course: Inserting Graphs

We will be using the following table throughout this lesson.

Source file: lesson7.xlsx

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