A step-by-step instruction on how to make a chart in Excel

In our life, we can not do without various comparisons. Figures - this is not always convenient for perception, that's why a man invented diagrams.

The most convenient program for creating graphs of different types is Microsoft Office Excel. About how to create a diagram in Excel, and will be discussed in this article.

This process is not so complicated, it is only necessary to follow a certain algorithm.

Step-by-step instructions on how to make a chart in Excel

1. Open the document: the "Start" button - "The whole list of programs" - the folder "Microsoft Office" - the document "Excel".

2. Create a table of the data you want to visualize in the diagram. Select the range of cells containing numeric data.

3. Call the "Wizard for the construction of graphs and diagrams." Commands: "Insert" - "Diagram".

The diagram wizard dialog box appears. It will help you to decide how to make a diagram in Excel. But for this work it is necessary to perform four simple steps.

1. The first step is to select the type of chart. As you can see from the opened list, there is a wide variety of these types: chart with areas, bubble diagram, histogram, surface and so on. Non-standard chart types are also available for selection. An example of the graphical display of the future graph can be seen in the right half of the window.

2. The second step in order to answer the question of how to make a chart in Excel is the input of the data source. It is about the very tablet, which was mentioned in the second paragraph of the first part of the article. On the "Row" tab, you can specify the name of each row (column of the table) of the future chart.

3. The most voluminous item number 3: "Chart parameters." Let's go through the tabs:

• Headings. Here you can specify the labels of each axis of the chart and give a name to it.

• The axes. Allows you to select the type of axes: time axis, category axis, automatic type detection.

• Lines of the grid. Here you can set or, vice versa, remove the main or intermediate lines of the grid graph.

• Legend. Allows you to display or hide a legend, and select its location.

• Data table. Adds a data table to the plotting area of the future chart.

• Data captions. Includes data signatures and provides a choice of a separator between the indicators.

On the screen appeared your creation. And although the Chart Wizard allows you to view the future schedule at each stage of your work, you still need to correct something in the end.

For example, by right-clicking on the chart area several times (but not by itself!), You can make the background on which the graph is colored, or change the font (face, size, color, underline).

If you double-click with the same right mouse button on the chart lines, you can format the grid lines of the diagram itself, set their type, thickness and color and change many other parameters. The construction area is also available for formatting, or rather, for coloring.

We hope that you have received the most understandable and simple answer to your question: "How to make a diagram in Excel?". Everything is very simple, if you follow the above instructions. We wish you success!