In Excel, a graph is a very important tool to visualize data from a table. So,** Making a Graph from a Table** is a necessary thing. In this article, I will show you 5 effective ways to **Make a graph from a Table in Excel**. We can use many types of graphs. In this article, I will use **Line chart, Bar chart, Pie chart, Scattered chart, **and** Histogram** to **Make a Graph from a Table**. Hope you will find the ways interesting.

**Table of Contents**hide

## Download Practice Workbook

Please download the workbook to practice yourself.

## 5 Effective Ways to Make a Graph from a Table in Excel

Let’s consider a dataset of **Yearly Sales of XYZ Traders**. The data table has 3 columns **B**, **C**, & **D **indicating data of **No**. **of Year**, **Cost**, & **Sales **respectively. The data table starts from the **B4 **cell and ends in the **D10 **cell. I will use this whole data table to make graphs from a table. I will show the whole procedure with necessary information.

### 1. Introduce Line Chart for Making a Graph from a Table

In this method, to **Make a Graph from a Table**, I will introduce **Line chart**. The procedure is straightforward and handy, Here I am going to show the whole procedure to **Make a Graph from a Table** using **Line Chart** with necessary illustrations.

**Steps:**

- First,
**Select**the columns of data you want to show in your graph. Here I have selected data ranging from**C4**to**C12**.

- Go to the
**Insert**tab on your**Toolbar**. You will find the**Line Chart**option there.

**Click**on the**Line Chart**You will find a**Dropdown**menu.**Select**the first option.

- Your graph will appear just like the one given below.

- To get other options to edit the graph,
**Go to**the indicated icon.

- After that, you will find this menu bar. You can use any of the options to edit the chart. I have edited the chart title.

- After all the edits, your graph will look like the one below.

**Read More:** **How to Plot Multiple Lines in One Graph in Excel**

### 2. Insert Bar Chart to Make a Graph from a Table

In this section, I am going to describe another method to **Make a Graph from a Table**. This is another easy method. I will insert a **Bar Chart **for **Making a Graph from a Table in Excel**. Hope this will make your skill stronger.

**Steps:**

- First, Select the data ranging from
**C4**to**D10**

- Then
**Go to**the**Insert**tab on your**Toolbar**. - After that,
**Select**the**Bar Chart** - Next,
**Select**the first option in the**3D Column**.

- As a result, you will see your
**Bar Chart**just like the chart given below.

**Read More: ****How to Create a Chart from Selected Range of Cells in Excel**

### 3. Apply Pie Chart for Making a Graph from a Table

In this article’s portion, I will introduce a new method to **Make a Graph from a Table**. This is a smart and handy way. I will apply **Pie Chart** to **Make a Graph from a Table**. Here is a new dataset table. In this table, there are two columns **B **& **C **which is indicating **No. of Years **and **Sales** respectively. I hope you will find the method interesting.

**Steps:**

- First,
**Select**the data ranging from**C5**to**C10**.

- Hence,
**Go to**the Insert tab on your**Toolbar**. **Select**the**Pie Chart**- Then
**Select**the first one of the**3D Pie**.

- You can see your pie chart just like the picture given below.
- Then, to insert data labels,
**Select**the**Icon**in the topmost right corner of the chart.**Click**on it. **Select**the**Data Labels**

- You will see the data labels on your pie chart just like the picture given below.

### 4. Use Scattered Chart to Make a Graph from a Table

Here, I will describe a new method to **Make a Graph from a Table**. This is a useful technique. I will apply **Scattered Chart** to **Make a Graph from a Table**. I hope This method will increase your Excel skills.

**Steps:**

- First,
**Select**the data ranging from**C5**to**C10**from the dataset.

- Then,
**Go to**the**Insert**tab of your**Toolbar**. **Select**the**Scattered**chart option from the**Ribbon**.- After that, you will see a
**Dropdown**menu there.**Select**the**Second one**.

- Then, you will see your scattered chart.
- Moreover, to edit the graph,
**Go to**the**Right Topmost Icon**of the graph.**Click**on it. - Hence, you will find options to edit the graph.

- Lastly, Your graph will be shown just like the graph given below.

**Read More: ****How to Make an X Y Graph in Excel (With Easy Steps)**

### 5. Make a Graph from a Table by Histogram

I will describe the last method for **Making a Graph from a Table **in this article. This is an important technique to visualize data in Excel. I will apply a **Histogram **to **Make a Graph from a Table**. I hope This method will increase your Excel skills.

**Steps:**

- Firstly,
**Select**the data ranging from**C5**to**C10**from the dataset.

- After that,
**Go to**the**Insert**tab of your**Toolbar**. - You will see the
**Scattered**chart option in the**Ribbon**.**Click**on it. - After that, you will see a
**Dropdown**menu there.**Select**the**First one**.

- After that,
**Go to**the**Right Topmost Icon**of the graph to edit just like the procedure described in the previous method.

- Hence, you will get your
**Histogram**graph just like the picture given below.

**Read More: ****How to Make a Lineweaver Burk Plot in Excel (with Easy Steps)**

## Things to Remember

- For every method described in this article, you should select the data you want to show in your graph, which needs to be selected first.

## Conclusion

You can find more recommended graphs in your excel. But in this article, I have described the mostly used methods. I hope these five methods will help you to visualize the data of a dataset by **Making graphs from a table in Excel**. I think you will find interested in these methods. If you have any kind of queries, feel free to ask me in the comment section.