Microsoft Excel's tabular processor is a universal tool to work with tables. Summary reports, prices, catalogs and more using functions for solving everyday tasks - All this is Excel. Dry numbers on the screen are only values \u200b\u200band indicators, diagrams are used for visual display.
1
Start the desired file, book or Excel sheet. Or create a new document through the menu of the right mouse button. After startup, the program window will open.
2
In the working window, select the area from which you want to build a diagram. If you need to display signatures to the values, then the table is highlighted completely. Otherwise, only values. There are several types of charts, determine for yourself the most suitable visual design:
Bar graph;
Schedule;
Circular;
Linear;
With regions;
Dot;
Exchange;
Surface;
Petal;
Combined.
3
There are several ways to build a diagram. Consider simple. Click the Insert tab and click on Recommended Charts. Mark the histogram with the grouping. Click OK.
4
Choose this type of diagram if you need to compare several values \u200b\u200bby category and if the list of categories is not important.
5
Build a petal diagram. Highlight the required interval in the table, tape laying Insert, recommended diagrams, petal chart. Used to display categories with respect to the central point.
6
Excel does not always build a diagram with the original idea, you need to edit the input data of the chart. On the diagram, click on the PCM and select Select Data ... or on the Tool Ribbon, in the Designer tab, click the corresponding icon.
7
If Excel incorrectly defined the source data, in the window that opens, edit the necessary values. In the Data Range Paragraph for the diagram, you can change the name of the row, select another range of values. Press on the right to the table icon, mark the correct range, extending the mouse on the table. Also, if you wish, you can change the values \u200b\u200bof the rows and rows. To do this, click Change, in the window that appears, the Legend elements (rows) elements select the desired row then change. By selecting the cells, enter the correct readings.
8
Initially, the diagram is created with standard names. You can change them by editing the legend. Click on the name diagram and enter the correct name.
9
When there is a lack of space on the current sheet, place the diagram on a separate one, to do this, click on the diagram to activate the Constructor tab. Click Move the diagram to move the name of your diagram and mark that it will be on a separate sheet. Click OK.
10
On a separate sheet with the name you specified, a chart will open.
A large number of chart available provides freedom in choosing necessary for every taste. All charts are interconnected with values \u200b\u200bin the tables for which they are made, the diagram changes when they are changed. This is convenient when making calculations for greater efficiency.
0
2358
