Sometimes, documents can use various numerical or statistical data. They can be written in a line or create a table, but for greater clarity, it is better to display them graphically. To do this, it is advised to make a diagram. How to create it, we will consider in this article.
Chart views
In Word and Excel there are many kinds of different diagrams. These include:
- Histogram - there can be a huge number of them: from ordinary to histograms with accumulations, normalized histograms and even voluminous ones. In addition, they can be cylinders, cones, pyramids and rectangles. It is displayed vertically.
- Chart - can be ordinary, with accumulations, with markers, accumulations, as well as voluminous.
- Circular - can be ordinary, volumetric, secondary, as well as whole or cut.
- Ruled - with grouping, with accumulations, normalized, volumetric, and also in the form of rectangles, pyramids, cones and cylinders. It looks like a histogram, only displayed horizontally.
- With areas - in the form of areas with accumulations, volume areas.
- Point - points with markers, points with curves.
- Stock - various types of stock charts, including in the form of Japanese candles.
- Surface - wire, contour, wire and contour.
- Annular - annular whole or cut.
- Bubble - bubble usual and volumetric.
- Petal - petal with markers, filled petal.
In addition, each of these types of diagrams has its own display methods.
Excel Chart
Consider how to make a chart in Excel. In order to create a diagram, click on the “Insert” tab, select the required view. If one of the default types of diagrams does not suit you, click on the “Other” button, where the remaining options are located.
In addition, you can open the pop-up menu for any of the diagrams and select the item “All types of diagrams ...”. After selecting the desired type, a window with a diagram will appear in the program.
Chart Fill
If, before creating the chart, the cells already had the necessary data to display them in the chart, do the following:
- Right click on the chart.
- Select the item "Select data ...".
- Select those cells from which information should be located in the created chart.
After these actions, a diagram will appear in the window, which can then be edited and formatted.
If you created the diagram in an empty file, then first you need to enter the necessary information in the cells, and then do the above steps.
Chart in Word
We figured out the basics of how to make a diagram in Excel. This is very necessary information, because when creating a chart in Word, you will first have to work in Excel. So, to create a chart in Word, you must also select the "Insert" tab and click on the "Chart" button.
A window will appear with various types of diagrams that are only in Word. Choose what you need, click on it, and then on “OK”. You will have a diagram and immediately an Excel file will open in which you can enter information for display in a diagram. With any changes to the document in Excel, the chart in Word will automatically change.
Chart formatting
We figured out the basics of how to make a chart in Word, but charts have a wide range of formatting options. To work on the chart format, you need to make the window with the chart active by left-clicking on it. At the top of the Word tab, the "Work with Charts" tab will immediately appear. It is with the use of this tab that all formatting occurs. This tab breaks into three more:
- "Designer";
- "Layout";
- "Format".
The "designer" is responsible for how to make a chart of a different type, select or modify data in Excel, choose options for the layout of charts, and change the color scheme.
The tab "Layout" makes it possible to insert various drawings, figures and inscriptions, as well as select the location of the header and the format of the data labels. Thanks to the "Format" tab, we can not use layouts for the color scheme, but, for example, choose the fill color for one or another fragment of the chart, as well as the contours and much more.
Example
To fully understand how to make a diagram, for example, create a pie chart in Word. We will indicate in it information on electricity charges by residents of three apartments. Suppose that in one apartment they pay 600 rubles, in the second - 1000 rubles, and in the third - 850 rubles.
Open the "Insert" tab in the "Word", click on the "Chart" button and select, for example, a cut pie chart. We will have a chart and Excel will open. In Excel, in the first column, starting from the second row, we enter the apartment numbers (sq. 1, sq. 2, sq. 3) and in the second, payment for electricity (600, 1000, 850 rubles). In the first line we indicate the name of the table, in our case, “Payment for electricity”. When you press Enter, all changes will be saved in the chart in Word.
Just like making a pie chart, you can create any others. In order for the user to display also the digital values of the chart, you must go to the "Layout" section and select "Data Signatures". You can place signatures in the center, inside and outside, use automatic arrangement.
Delete chart
How to make a chart figured out, but what if you no longer need a chart? Removing it is very simple, both in Word and Excel.
So, to delete a chart, you need to right-click on the chart window and select "Cut". The chart disappears, but if you delete the chart in Excel, the information that it displayed remains.