How to make a graph in Excel

In Excel, graphs are made to visually display the data that is recorded in the table. Before drawing a graph in Excel, you must have created and formatted a table with the data entered into it. The table is best done on the Insert tab.

To make graphs in Excel 2010, you need to start by preparing a table

By clicking on the Table icon, a window will open in which the table parameters are set. The completed table is formatted on the main tab by clicking on Format as table and choosing the style you like. The internal and external lines of the table are set on the main tab by clicking on Other tabs, while it is necessary to select the entire table. When the table is ready and filled in, you can start plotting graphs in Excel with two axes.


You can build graphs in Excel 2010 on the Insert tab

Before you start plotting in Excel, move the cursor over a cell in the table and press the left mouse button. To create a graph in Excel, go to the Insert tab and click Graph. Choose from the proposed charts the one you need and it will immediately be displayed. When you finish building graphs in Excel, you need to edit them.


When you have finished building an Excel chart, you need to edit it.

Move the cursor over the chart and press the right mouse button. A context menu will open with several options.


To label the chart axes in Excel 2010, you need to move the cursor over the chart area and press the left mouse button.


You can sign the axes on the chart in Excel on the Layout tab

After that, the Layout tab will appear on the toolbar and you need to go to it. On this tab, click on Axis Title and select Primary Horizontal Axis Title or Primary Vertical Axis Title. When the names are displayed on the axes of the graph, they can be edited by changing not only the name, but also the color and font size.

Video

This video shows how to plot a function in Excel 2010.