EducationColleges and Universities

Special opportunities: how to build a schedule in Excel

It's hard to find a program that can replace Excel: working with numbers, tables, formulas in it is simple and convenient. But not always the data placed in the table is convenient to analyze, but on the diagram it is possible to clearly see what happened to the indicators in the period under study.

However, 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 the calculator. Let's say you need to clearly demonstrate how the sales volume has changed throughout the year. First, create a table in which you will specify the months and the number of goods sold in each of them, for clarity, it is better to use the data for at least 2 years. To see these figures in the picture, select all the data you entered and on the "Insert" tab, select the "Chart" item. Let's look at what opportunities Excel offers you.

After you have selected the specified menu item, you will see a special built-in program called "Chart Wizard". Usually from now on, many people understand how to build a schedule in Excel, because many people do not try to figure out what other opportunities are opening up for them.

So, depending on your needs, you can choose the type of chart that suits you best: it can be one of the standard or non-standard variants. Before you figure out how to build a chart in Excel, you first need to decide in which form values should be displayed. So, the program will offer you to create a simple or volumetric graph, a histogram, display data in the form of a circle or a ring (where it will be indicated how much this or that indicator takes in the total amount). You can choose another option that will visually display your data.

After you have decided on the most appropriate type of chart, in the "Chart Wizard" program you need to click the "Next" button. In the next step you will be asked to specify the range of data and choose how to display the results. For example, you can build a chart in Excel, which will display the dynamics of changes in sales during the year, or it is shown, the number of goods sold in each month in relation to the previous period has grown or fallen.

After the definition 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 symbols on the graph, where and what year is displayed), mark the grid lines and specify the data values, if necessary. Do not assume that this information is not useful to you. If you have more than one graphic on the sheet, it is very important to sign and mark each one properly. Even if you know how to build a chart in Excel, this does not guarantee that you will always remember which data each displays.

The last step is to select the location of the chart: most often they are placed next to the table, right on the working page of Excel, but you can put them on a separate sheet. If you need to draw a graph in the Word, you can just copy it from Excel. Of course, Word offers the ability to build diagrams: select the "Drawing" menu on the "Insert" tab, one of the items in it will be "Diagram". But when you click on it, you will automatically be redirected to Excel.

Similar articles

 

 

 

 

Trending Now

 

 

 

 

Newest

Copyright © 2018 en.birmiss.com. Theme powered by WordPress.