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

Make a graph from a table in Excel" width="487" height="354" />

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

Make a graph from a table in Excel" width="487" height="355" />

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.

Make a graph from a table in Excel" width="380" height="166" />

• Select the first option on the dropdown menu.

Make a graph from a table in Excel" width="487" height="511" />

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

Make a graph from a table in Excel" width="468" height="290" />

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

Make a graph from a table in Excel" width="531" height="346" />

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

Make a graph from a table in Excel" width="481" height="353" />

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

Make a graph from a table in Excel" width="518" height="478" />

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

Make a graph from a table in Excel" width="356" height="349" />

Steps:

Make a graph from a table in Excel" width="356" height="349" />

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

Make a graph from a table in Excel" width="376" height="478" />

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

Make a graph from a table in Excel" width="360" height="358" />

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

Make a graph from a table in Excel" width="375" height="520" />

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

Make a graph from a table in Excel" width="789" height="394" />

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

Make a graph from a table in Excel" width="359" height="352" />

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