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.

Instruction

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.

Is the advice useful?