Special features: how to build a graph in the "Excel"

click fraud protection

hard to find a program that can replace Excel: Working with figures, tables, formulas it is easy and convenient.But not all data contained in the table, it is convenient to analyze, but on the chart you can clearly see what is happening with those in the study period.

However, not everyone knows how to plot a graph in the "Excel", many are not even aware that this program can be used not only as a substitute for a calculator.Let's say you need to demonstrate how to change the volume of sales during the year.First, create a table that is listed and the number of months of goods sold in each of them, for clarity, is better to use the data for at least 2 years.To see these figures in the picture, select all data you entered, and on the "Insert", select "Graph".Let's look at what opportunities are you offering Excel.

Once you have chosen a specified menu item, you will see a special built-in program "Chart Wizard."Usually this moment it becomes clear to many how to build a graph in the "Excel", because many people do not try to find out what other opportunities open to them.

So, depending on your needs, you can choose the right type of chart: this may be one of, or has a non-standard options.Before figuring out how to build a graph in the "Excel", first is to determine the form in which values ​​are displayed.Thus, the program prompts you to build simple or volume graphs, histograms, display the data in the form of a circle or ring (which will indicate which part takes one or another indicator of the total amount).You can select another option, which will visualize your data.

Once you have decided on the most suitable type of graph in the "Chart Wizard" to press "Next" button.In the next step you will be asked to specify the data range and choose whether to display the results.For example, you can plot a graph in the "Eksele", which will show the dynamics of changes in sales volumes during the year, or show increased or decreased the amount of goods sold in each month compared to the previous period.

After defining these indicators in the next step you will be asked to sign an axis, enter a name for the chart, add a legend (to sign directly on the chart legend, where and what year is displayed), to mark the grid lines and to specify the data values, if necessary.You should not assume that this information is not useful to you.If the sheet you will have more than one schedule, it is important to sign and properly mark each of them.Even if you know how to plot a graph in the "Excel" it does not guarantee you that you will always remember what data displays each of them.

The last step is to choose the location of the diagram: often they are placed next to a table, right on the page, Excel, but you can make them on a separate sheet.If you need to draw a graph of "the Word", then you can simply copy from the "Excel".Of course, Word offers the possibility of charting: Select the tab "Insert" menu "Picture", one of the items in it will be "Diagram".But when you click on it you will still be automatically redirected to the program Excel.