You do not know how to build a chart in Excel

If you are faced with the question "How to build a chart in Excel?", Then this article is exactly what you need.

For charting in Excel, as well as for building all types of graphs (for example, histograms), the Chart Wizard answers.

So, let's get started.

1. Open the document MS Office Excel. Start - All programs - Microsoft Office - Microsoft Office Excel.

2. Start the Wizard for constructing all the diagrams. On the top toolbar, select "Insert", then - Chart.

3. The chart wizard is started. To complete its work, you must complete four steps:

1) Select the type of future chart. Fourteen types are available for construction: petal, histogram, cylindrical, ruled, bubble, graph, circular, dotted, with regions, annular, surface, stock, conical, pyramidal. In turn, when selecting a type when switching to the "Custom" tab, you can select a non-standard chart view. Further…

2) Select the range of data. If you advance, i.e. Before starting the wizard, you selected the required range for the future diagram, then the field will be filled automatically, otherwise - just select the data range in the second stage of the Charting Wizard. In the "Row" tab, you can specify the names of the axes or bullet values of the chart.

3) Select chart parameters. This is not an obligatory item, but is desirable for complete filling. Without it, the diagram will be built, but if you are still interested in how to build a diagram correctly in Excel, then you should fill it to the maximum. The "Headers" tab provides an opportunity to name the future chart, as well as its axes. The "Axis" tab is required to select the type of axes signatures. The "Grid Lines" section allows you to display or not display the main and intermediate construction lines on the graph. The section "Legend: Selecting the location of the legend (explanation of the values): Data tables" makes it possible to display the data on which the graph was plotted right in the area of its construction. The "Data Signatures" tab allows you to sign each chart marker with the choice of a convenient delimiter between the values.

4) Select the location of the chart. If, for example, you are interested in how to build a histogram in Excel on a separate sheet, select the "Single" item and specify the name of the new page. Done!

These four steps are the simplest answer to the not so complicated question of how to build a diagram in Excel.

Now let's look at the question of editing or formatting the result.

Before you the diagram. Suppose you need to change its appearance a little. How to build a chart in Excel with italic font legend?

Answer: just click the left mouse button a couple of times against the chart background. With this action, you will open the "Format Chart Area" window, where you can not only change the font used in the construction area, but also select a frame with an adjustable line type, color and thickness, and add a shadow effect to the frame.

By double-clicking on the diagram, you will open the "Format of the construction area" window, where you can also change the view of the frame.

Double-click on the grid lines will cause the "Grid Lines Format". Here, the appearance of the lines (type, color, thickness) can be affected, as well as the scale. On the "Scale" tab, you can set the division price, the price of intermediate divisions, the minimum and maximum values, and other parameters.

If your question sounds more specific, for example: "How to create diagrams in Excel 2010?", The answer will differ from this article only in that in MS Office Excel, the diagram wizard is called by a separate button on the standard toolbar. All other actions will be performed according to the above algorithm.

A diagram is not always a complex construction. Refer to Excel and see for yourself. Good luck!