Advice 1: How to build a radar chart

Charts are used in the table editor Microsoft Office Excel for a visual presentation of the data from the spreadsheet. Radar chart is a variation of the pie chart, but here it is in a separate type. This form of data presentation is convenient to use, for example, to display multiple groups of data distributed across the months of the year.
How to build a radar chart
Run the table editor and load a document whose data must be represented in the format of a radar chart.
Select the range of cells that you want to include in the chart. If this range contains the column headings and columns, they can also be highlight - Excel will be able to distinguish labels from data cells, and include in chart as legends and labels to the sectors. It is desirable that the number of columns with data does not exceed seven - that is the recommendation of Microsoft Corporation.
Click on the "Insert" menu in the table editor and the command group "Diagram", click "Other charts". The bottom line the drop down list placed three options for radar graphs - select the one you want. Excel will perform the necessary actions and put the finished figure on the same page of the document. While in the menu editor adds three additional tabs used to edit the chart - "Layout", "Format" and "Designer". The default activated tab "Designer".
Open one of the drop down lists in groups and teams "chart Layouts or chart Styles" if you want to change the appearance, used editor to create the chart. These lists are placed ready design options and in the tabs "Layout" and "Format" you will be able to customize almost every aspect of the appearance of a radar chart is to choose the color, relief, material, shading, color fill options, move labels or disable them, etc.
Use the buttons in the command group "Data" tab the "Designer", if you want to change the cell range that is used for the formation of charts, or row and column containing the headings of the legend. In the group of commands Type" - on this tab, placed button to save your created styles as a template and a button replace the radar charts on the chart of any other type. Button in the command group "Location" buttons to move the chart within the current worksheet or on other worksheets in the workbook.

Advice 2: How to build a chart in Excel

Illustration of the calculations in the form of charts and graphs is a great opportunity to make the reports more visual. The information presented in the form of visual images, is remembered much better. One way to improve the perception of the results of the study is the translation of dry figures of statistics in visual images acsalaska charts.
How to build a chart in Excel
To build the chart in Excel, enter the required data in tabular form. Highlight their full range and click on the "chart Wizard" on the toolbar. A similar effect happens if you select the menu "Insert" command "Diagram...".
In the window that appears, select the appropriate chart type. Some of the chart types to choose depends on the information that illustrate the input numbers as well as your personal taste. Complicated statistical series look good in the form of a simple histogram, which can then give a three dimensional look. At the same time, simple percentages and tables consisting of two columns, adequately perceived in the form of a pie chart as the chart with the selected sectors.
The following settings window will specify the ranges of data used. To build the chart in Excel, enter the signature of the X and Y axes if necessary. Additionally, specify whether to add a legend to the chart and the data labels. After you select the location of the chart on the same worksheet, where the table itself with the data or on a separate Excel worksheet. In the latter case, the table will occupy all the space of the new sheet, and when printing it massturbate on full size paper.
Later you can change the appearance and customize the chart by clicking on it the right mouse button and selecting in the drop-down list one of the commands: type, source data, options and location.

Advice 3: How to build a Pareto chart

Curve or Pareto chart is a graphical representation of the Pareto law, which determines the dependence of the distribution of resources from the aggregate of many reasons. This diagram is used to identify the priorities that need to be addressed to resolve problems (for example, the presence of unsold goods, hardware problems, etc.).
How to build a Pareto chart
There are two types of Pareto charts – the results of operations and reasons.

The first is used to determine the main problems, this diagram shows the undesirable results of operations associated for example, with safety or with quality.

The latter is used to identify all of the causes of the problem and determine the main one (for example, inefficient work method, poor performer, contractor, foreman, etc.).
Build a Pareto chart starts with problem definition. You need to determine the issue that will be explored (for example, defect products), to define data and their classification (e.g., type of defect, for reasons of appearance, place of occurrence, etc.), to define the terms and methods.
Compile a sheet containing a list of the information collected. Prepares and populates a table containing the list of found problems (e.g., defects) in order of importance. The table thus consists of the following columns:

• Types of issues (defects, accidents, etc.)

• The number of problems

• The cumulative sum of the number of problems

• The percentage of problems for each characteristic to the total amount

• Accrued interest.
Built coordinate axis. The vertical axis percentage, horizontal interval corresponding to a number of attributes (issues). In accordance with the prepared table on the coordinate plane is constructed a cumulative curve, on a graph apply all the available information related to the diagram and to study data.

After constructing the diagram, it is possible to identify the main causes of the problem under study, the use of different types of analysis such as ABC analysis.
Useful advice
If data is presented in monetary terms, it is clearer to change the vertical and horizontal axis interchanged.
To more accurately determine the causes of certain problems, it is advisable to build several Pareto charts, using different input data.

Advice 4: How to build a Gantt chart

Chart Gantt (Gantt, Gantt chart or strip chart") is a method of visual presentation simultaneously and/or sequentially occurring events. Often used in the planning of joint action of several persons or groups.
How to build a Gantt chart
Start by constructing the so-called "field diagram". It is a two-dimensional grid, horizontal top (indented) are deposited periods of time in accordance with the projected duration of the actions vertically on the left – a list of scheduled events or tasks sequentially, the rows from top to bottom, one row per job. It should be remembered that the task list is a sequence of necessary actions which need to be made to ensure that the task was completed.
Leave free space to the right of the task list to specify the assignees for each task.
Ograniciti dotted lines across the chart height, top to bottom, start time, task execution time and total end. For example, a family going to the theatre. Fees start 17:00 end point (point of release) 18:00.
Then the points denote the beginning and completion of each task. For going to the theater, for example, the first – order a taxi (17:00-17:10).The second task is going and worn Mama (17:00-17:40), and the third is going to and dresses daddy (17:10-17:30), the fourth dress children (17:30 – 17:50). The last task before leaving: check the "everything is taken, nothing is forgotten" (17:50 – 17:57). Enter in the left free space in front of each task performers.
The gaps between the start point and end point for clarity, superimposed on length. Can different colors. In larger diagrams, the same colors are marked or similar action or actions in one phase, it is Important to understand this: the shaded intervals indicate on the diagram the execution time of a scheduled mandatory actions. For example, the father, after dressing in 17:30 could then sit to read the newspaper until 17:50 (target dress is made), and can help children get dressed and ready. However, if the goal was to "help children together" is required, it is included as a separate line in the chart , for example, is assigned to the Pope, from 17:30 to 17:50.

Advice 5: How to build a chart in word

Now all the reports are basically the same on the computer using different graphical and text-based programs. Most often used Word from the MS Office package. It allows you to build charts and graphs of their own resources and import them from the table editor Excel.
How to build a chart in word
You will need
  • computer;
  • - MS Word.
To build a chart in MS Word 2007, in the main menu enter in the "Insert" tab, then click "Chart". A window appears in the left part which shows the list of templates, diagrams, and the right of their views.Choose the graphwhich, in your opinion, for your report, and confirm the selection by pressing the OK button. The trace window opens the table editor MS Excel table corresponding to the selected chart. Thus, on the screen two Windows: Word and Excel. Double-click the table cell and change its value. The chart appearance will change after you press the Enter key.
You can create a chart in Word from the table. In the tab "Insert" click "table". You will be asked to choose several ways to create one:1. To determine the pattern size of the table;2. After you select the command "Insert table" in the window "Insert table" to define its parameters: the number of rows and columns and AUTOFIT column widths;3. Choose "Draw table", if you need a table with predetermined parameters. You receive the Pencil tool. Draw rows and columns of the desired size;4. The command "Excel spreadsheet" at the bottom of the window opens the table editor. Enter the values of the cells to complete the entry, press OK;5. The command "Express table" some table templates.
Fill the table with data. In the main menu choose the item "Menu". In the line of the new menu, expand "table", then click "Select" and "Select table". In the same line of scroll through the options "Insert" and "Object". In the list of "object Type", locate "Microsoft Graph Chart". The program will offer the most suitable for your table as the chart type. If you want to change it, click the picture twice, and choose from the menu "Chart" and "chart Type". To return to the Word document, click anywhere outside the picture.
To import a table from Excel, select the cells or entire worksheet, and copy the selection to the clipboard Ctrl+C. Open a Word document, mark the place where to insert the table, and press Ctrl+V. with the new data button will appear "paste Options". If you want the table reflect all the changes that will be made to the original document, choose one of the paragraphs "Keep source formatting and link to Excel" or "Use destination table style and link to Excel".

Advice 6: How to build a chart

To build chart you must have at least some knowledge, start to act immediately by several methods. Tables Excel is a powerful tool with which you can process huge amounts of data to make a variety of computing, display them in tables, and the process of visualization becomes easy and convenient.
How to build a chart

The diagram is one way of data representation. Consider two versions - 2003 and 2010, and versions 2007 charting is similar to the 2010 version, so consider this version of the program will not. So, how to make a chart version 2003?

1. Run the program. In a new workbook enter the data table.

2. Allocated to the prepared table.

3. Go to the menu “Insert”, select “Chart”.

4. In the window select the type of graph that you like, such as a conventional histogram.

5. Click “Next”.

6. You will see a window where you need to choose the source for the build. Initially, the selected source data table, so they will be recorded automatically in the field “Range”.

7. Again, click “Next”.

8. Now the chart setup. Here you can define the title and name the axes, configurable legend, set the caption to data. Nothing complicated, in just understand.

9. In the final window, choose the place where you insert the chart.

10. Ready!

How to make a chart from the 2010 version:

1. Run the program, fill the table with the relevant data.

2. Allocated to her.

3. Again the group Insert “Insert”, then bar Charts.

4. Select a chart type.

5. Once you have selected the chart type, the chart is automatically inserted into the worksheet where the data table.

6. All settings for the chart can be done if you click the graph, right-click and go to Format Chart Area.

To graph it is also possible for a different program standard Microsoft Office package, text without leaving the word program. If you made a table there, go to “Insert” on the top bar and choose the icon with the graph. Clicking on it will call up a window where again, you must select the most suitable for your chart and click “OK”. After that, you will come up a window where you need to draw a table with data, and a picture of the chart will already be inserted in the vordovsky document. As soon as you enter the data in the table will change the figures inserted in the graph document. Labels to the chart, you can also sign in table and necessary settings are made, if you click on the picture right mouse button. In the drop-down menu will appear a lot of interesting settings, including changing the chart type, changing the labels, and the like. Thus diagrams in a text document. As you can see, there are no difficulties and the result is obvious, you can easily cope with this task independently.


Is the advice useful?