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

Let’s consider a dataset of Yearly Sales of XYZ Traders. The data table has three columns, B, C, and D, indicating the data of No. of Year, Cost, and Sales, respectively. The data table starts from the B4 cell and ends with the D10 cell.

Method 1 – Introducing a Line Chart to Make a Graph From a Table

Steps:

• Select the columns of data you want to show in your graph.

• Go to the Insert tab on your Toolbar and click on the Line Chart option.

• Select the first option on the dropdown menu.

• A graph just like the one pictured below will appear.

• To get other the options to edit the graph, click on the indicated icon:

• Use the options to edit the chart according to your preferences. For instance, you can edit chart title.

• After all the edits, your graph should look like the one below.

Method 2 – Inserting a Bar Chart to Make a Graph From a Table

Steps:

• Go to the Insert tab on your Toolbar.
• Select the BarChart option.
• Choose the first option under the 3-D Column section.

• You should see a Bar Chart just like the one pictured below.

Method 3 – Applying a Pie Chart to Make a Graph From a Table

For this method, we need a new dataset table. In this table, there are two columns, B and C, which indicate the No. of Year and Sales, respectively.

Steps:

• Go to the Insert tab on your Toolbar.
• Click on the Pie Chart button.
• Choose the first 3-D Pie option.

• To insert data labels, click on the Plus icon in the top-right corner of the chart and select the Data Labels option.

• Data labels will appear on your pie chart, as pictured below.

Method 4 – Using a Scattered Chart to Make a Graph From a Table

Steps:

• Go to the Insert tab on your Toolbar.
• Select the Scattered Chart option from the Ribbon.
• Choose the second option from the dropdown menu.

• To edit the graph, click on the Plus icon in the top-right corner of the graph.

• After making the necessary changes, your graph should look like the graph below.

Method 5 – Using a Histogram to Make a Graph From a Table

Steps:

• Go to the Insert tab of your Toolbar.
• Click on the Scattered Chart option in the Ribbon.
• Select the first option from the dropdown menu.

• Navigate to the Plus icon in the upper-right corner of the graph to edit it.

• You should end up with a Histogram graph like the one pictured below.

Things to Remember

• For every method described in this article, you must select the data you want to show in your graph first.

Download Practice Workbook

Feel free to download the workbook below to practice on your own.