It's hard to find a program that can replace Excel: working with numbers, tables, formulas is simple and convenient. But it is not always convenient to analyze the data placed in the table, but on the diagram you can clearly see what happened to the indicators in the period under study.
True, not everyone knows how to build a graph in Excel, many do not even realize that this program can be used not only as a replacement for a calculator. Let's say you need to visually demonstrate how sales volume changed during the year. To get started, create a table that will indicate the months and the number of goods sold in each of them, for clarity, it is better to use data for at least 2 years. To see these indicators in the picture, select all the data you entered and on the "Insert" tab, select the "Chart" item. Let's take a look at what Excel has to offer.
After you have selected the specified menu item, beforeyou will see a special built-in program "Chart Wizard". Usually, from this moment on, it becomes clear to many how to build a graph in Excel, because many do not try to figure out what other opportunities open up before them.
So, depending on your needs, you can choose the type of chart that suits you: it can be one of the standard or non-standard options. Before you figure out how to build a graph in Excel, you first need to decide in what form the values \u200b\u200bshould be displayed. So, the program will offer you to build a simple or three-dimensional graph, a histogram, display data in the form of a circle or a ring (which will indicate what part this or that indicator occupies in the total amount). You can choose another option that will visually display your data.
After you decide on the most suitable type of chart, in the "Chart Wizard" program, you must click the "Next" button. In the next step, you will be prompted to refine the data range and choose how the results are displayed. For example, you can create a graph in Excel that will show the dynamics of changes in sales during the year, or show whether the number of goods sold increased or decreased in each month in relation to the previous period.
After determining with these indicators, at the next stage you will be asked to label the axes, enter a name for the chart, add a legend (sign the symbols directly on the chart, where and which year is displayed), markgrid lines and specify data values, if necessary. Do not assume that this information is not useful to you. If you have more than one graph on the sheet, it is very important to sign and label each of them properly. Even if you know how to build a graph in Excel, this does not guarantee that you will always remember what data each of them displays.
The last step is to choose the location of the constructed chart: most often they are placed next to the table, right on the Excel working page, but you can also put them on a separate sheet. If you need to draw a graph in Word, then you can simply copy it from Excel. Of course, Word offers the ability to build charts: select the "Picture" menu on the "Insert" tab, one of the items in it will be "Chart". But when you click on it, you will still be automatically redirected to the Excel program.
