Advice 1: How to build a histogram in Excel

The histogram is a graph in which the data is displayed in columns. The height of the columns depends on amount of data, and the interval between them – from the period of time during which these data were collected.

Instruction
1
Create a table and enter data, based on which you will build the histogram.

2
Select random cell from the table. In the menu "Insert" select "Chart" or click on the icon "chart Wizard" on the toolbar. To create a histogram with the default settings, after selecting the cell, press F11. The histogram is created on a separate sheet.
3
Select from the list the type "Histogram". In the "Appearance" section, specify the subtype. In the lower window is displayed in a tooltip-a description that will help you to make a choice. Click on the "Result" to see how it will look like the histogram based on your data. Go to the tab "Custom" if you want to create a custom histogram – for example, in combination with the chart, or area. To continue the build, click Next.
4
In the next window you should specify the range of data to build the histogram. The default is whole table. Highlight those cells whose content should be displayed in the histogram. In the "Range" dialog box, specify the desired values. With the switch from "Rows" to determine which setting will be indicated on the horizontal axis – the rows or columns. Click "Next" to continue.
5
In the "chart Options" on the tab "Headers" provide a title for your histogram and axes, if they deem it necessary. Navigating the tabs, you can make drawing in line with job he needs to illustrate. In the preview window displays all the changes you make. To continue, click "Next".
6
In the last step, specify the Excel editor, where you intend to place the histogram to embed it in a worksheet or placed on a separate sheet. Select the desired value and click "finish" to complete the work.

Advice 2: How to draw a histogram

Once again, I began the task of carrying out sociological research. It involves processing a large data array. But in addition they need to visualize that person not familiar with the affected subject, it became clear what was going on. How to construct a histogram?
Instruction
1
Draw a histogramusing a computer program. In the histogram the most important elements are the sign and the distribution. A sign is a phenomenon that you are studying in your study. Distribution - a set of answers points.
2
Build a two-dimensional coordinate plane. X will post the answers and the points on the y-axis is the frequency of their occurrence. Mark the results on the chart so that in the end, you get vertical columns, whose number coincides with the number of selected features. Their height must match the frequency of their occurrence. That information was perceived better paint columns in different colors. Color pick so that they don't "cut" the eye.
3
Open the application Microsoft Word. On the toolbar, select "Insert", click on it with the left mouse button and clicking on "Illustration". The illustrations look Charts. You will see a window with various kinds of graphs. Select histogram.
4
Click OK. Often to the toolbar rendered icon charting. Click on it and do the same thing. A window will appear with the data table. To draw a histogram, fill in these columns with all the necessary information. Click OK. The worksheet will appear in the histogram. To correct it, double-click it with the left mouse button. Thus you can rename the columns and axes.
5
Open the Microsoft Excel application. The histogram build it much easier and more convenient than in Word, because it is easier to adjust the interval covered by the values. In an empty cell enter data corresponding to the coordinates. Then do the same things that you did in Microsoft Word. In the line "range", specify it manually or select filled cells.
Search
Is the advice useful?