In our life, just can not do without various comparisons. Numbers - this is not always convenient for perception, which is why people came up with diagrams.
The most convenient program for building graphs of various kinds is Microsoft Office Excel. How to create a chart in Excel will be discussed in this article.
This process is not so complicated, you just have to follow a certain algorithm.
Step-by-step instructions on how to draw a chart in Excel
We open the document: the Start button - the entire list of programs - the Microsoft Office folder - the Excel document.
We create a table of data that we want for visual reproduction on the diagram. Select the range of cells containing numerical data.
We call the "Wizard of building graphs and charts." Commands: "Insert" - "Chart".
A
dialog box appears for
the wizard to build diagrams. It will help you decide
how to make a chart in Excel. But for this work, four simple steps must be completed.
The first step will be to select a chart type. As you can see from the list that opens, there is a wide variety of these types: a graph with areas, a bubble chart, a histogram, a surface, and so on. Non-standard chart types are also available for selection. You can see an example of a graphic display of a future chart in the right half of the window.
The second step in order to answer the question of how to make a chart in Excel is to enter a data source. We are talking about the same tablet, which was mentioned in the second paragraph of the first part of the article. On the “Row” tab, it is possible to specify the name of each row (table column) of the future chart.
The most voluminous item number 3: "Chart parameters." Let's go through the tabs:
Headlines. Here you can specify the labels of each axis of the diagram and give a name to it itself.
Axles. Allows you to select the type of axes: time axis, category axis, automatic type detection.
Grid lines. Here you can set or, conversely, remove the main or intermediate grid lines of the chart.
Legend. Allows you to show or hide the legend, as well as select its location.
Data table. Adds a data table to the plot area of the future chart.
Data signatures. Includes data signatures and provides a choice of separator between measures.
The last and shortest step in order to build a chart in Excel is to choose the location of the future chart. There are two options to choose from: the original or the new sheet.
After all the necessary fields in the dialog boxes of the Chart Wizard are filled, feel free to click the "Finish" button.
Your creation has appeared on the screen. And although the Chart Wizard allows you to view the future chart at each stage of your work, in the end, you still need to fix something.
For example, by right-clicking a couple of times in the chart area (but not on it!), You can make the background on which the chart is located colored or change the font (style, size, color, underline).
By double-clicking with the same right mouse button on the lines of the chart, you can format the grid lines of the chart itself, set their type, thickness and color, and change many other parameters. The construction area is also available for formatting, or rather, for color design.
We hope that you have received the most understandable and simple answer to your question: “How to make a chart in Excel?”. Everything is very simple if you follow the above instructions. We wish you success!