How to Make a Graph from a Table in Excel (5 Suitable Ways)

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