How to build graphics? In Excel!

Any process in our life, one way or another, is connected with numbers. In medicine, we see numerical indicators, in food we count the number of calories, in activity we consider expediency and so on.

Most often, graphs are used to observe quantitative changes. They allow you to visually see the numerical process.

For working with charts, the Excel office application is most convenient. It's quite easy to build a chart in Excel . No ruler, pen, calculators, or simple pencils is required. For you, everything will easily make a computer.

So, if you are wondering how to build graphics in Excel, then look for the answer in this article.

Before you create a chart in Excel 2010 or Excel 2003, you must open a blank document. As a rule, by default the name of an empty file in this program is "Book1".

We execute the following set of commands:

Start button (lower left corner of the monitor), All list of installed programs, Microsoft Office, Excel.

The first task is completed.

The next step is to create a tabular data form for graphical display. Make the table, enter the necessary indicators in it, headers and columns.

The second step is completed.

And now, on your question about how to build graphics in Excel, the "Chart Wizard" will respond, which you need to call from the toolbar. To do this, click on the following buttons: Insert, Chart ...

The wizard will easily build any chart or histogram, requiring only four steps.

Let's get started.

First step.

In this case, you are asked to choose the type of the future chart. The variety of options is impressive: spot, pyramidal, bubble, with areas, petal, etc. The form of the future construction can be viewed in the same dialog box, in the right half of it.

Second phase.

Digital stage of work. Here you need to select the metrics for the future chart. To do this, select the data table created earlier. At the same stage, the names of the series are given.

The third stage.

The widest in execution. It will lead you to an answer to the question of how to build graphics in Excel the most informative. For correct filling, let's go through the tabs.

1. Legend. Adds the row labels to the boundaries of the chart or, on the contrary, removes the existing ones.
2. Lines of the grid. Allows you to add or remove intermediate and basic lines of the grid.
3. The axes. Selects the axis type.
4. Headings. Specifies the names of each axis of the chart.
5. Data table. Adds or removes the table with numerical values, on the basis of which the construction is performed in the corresponding area.
6. Data captions. Signs each point of the graph (row, category, value).

The fourth stage.

Final. In it, the "Build Wizard" will offer you the choice of the location of the future chart. There are two options to choose from: on the existing sheet (along with the text and numeric table) or on a clean new sheet.

After all four steps of the "Charting Wizard" work are completed, feel free to click the "Finish" button and the answer to the question about how to build graphics in Excel, you know! Agree that it is much easier than it seems at first glance. The theory must always be backed by practice. So, try it! You will succeed.

Good luck!