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.

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

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, and 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 the 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 a **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 a 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 Make an X-Y 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 skills 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 indicate **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Â**option.

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

**Read More: **How to Make a Graph in Excel That Updates Automatically

### 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 a **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 Plot Graph in Excel with Multiple Y Axis

### 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 Display Percentage in an Excel Graph

## 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.

**Download Practice Workbook**

Please download the workbook to practice yourself.

## Conclusion

You can find more recommended graphs in your Excel. But in this article, I have described the most 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 interesting in these methods. If you have any kind of queries, feel free to ask me in the comment section.

**<< Go Back To How to Create a Chart in Excel |Â Excel Charts |Â Learn Excel**