Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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.


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.

Make a graph from a table in Excel


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.

Line chart to Make a graph from a table in Excel

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

Line chart to Make a graph from a table in Excel

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

Line chart to Make a graph from a table in Excel

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

Line chart to Make a graph from a table in Excel

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

Line chart to Make a graph from a table in Excel

  • 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

Bar chart to Make a graph from a table in Excel

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

Bar chart to Make a graph from a table in Excel

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

Pie chart to Make a graph from a table in Excel

Steps:

  • First, Select the data ranging from C5 to C10.

Pie chart to Make a graph from a table in Excel

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

Pie chart to Make a graph from a table in Excel

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

Scattered chart to Make a graph from a table in Excel

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

Scattered chart to Make a graph from a table in Excel

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

Scattered chart to Make a graph from a table in Excel

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

Histogram chart to Make a graph from a table in Excel

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


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo