It is hard to find a program that can replace Excel: working with numbers, tables, formulas in it is simple and convenient. But far from always the data placed in the table is convenient to analyze, but on the diagram you can clearly see what happened to the indicators during the study period.
True, not everyone knows how to build a schedule in Excel, many do not even realize that this program can be used not only as a replacement for a calculator. Suppose you need to demonstrate how
sales have changed over the course of a year. First, create a table that will show the months and the amount 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 "Chart". Let's look at what features Excel offers you.
After you have selected the indicated menu item, a special built-in program “Chart Wizard” will appear in front of you. Usually, from this moment on, it becomes clear to many how to build a schedule at Excel, because many do not try to figure out what other opportunities open up for them.
So, depending on your needs, you can choose the type of chart that suits you: this 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 should be displayed. So, the program will offer you to build a simple or three-dimensional graph, a histogram, display the data in the form of a circle or a ring (where it will be indicated which 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 asked to refine the data range and choose a way to display the results. For example, you can build a graph in Excel, which will show the dynamics of changes in sales over the year, or show whether the number of goods sold increased or fell in each month in relation to the previous period.
After determining with these indicators in the next step, you will be asked to sign the axes, enter a name for the chart, add a legend (sign the legend where and what year is displayed directly on the chart), mark the grid lines and indicate data values, if necessary. Do not assume that this information is not useful to you. If you have more than one chart on the sheet, it is very important to sign and mark each of them properly. Even if you know how to build a schedule in Excel, this does not guarantee you 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 work page, but you can 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 the "Chart". But when you click on it, you will still be automatically redirected to Excel.