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.

Instruction

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.

Is the advice useful?