How to repair a faucet
5 Rules resistant manicure

How to build a histogram in Excel

How to build a histogram in Excel

Histogram - a graph in which the data are displayed as columns.

The height of the columns depends on the amount of data, and the interval between them - from the time interval during which these data were collected.



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


Highlight the cell selected at random from thistable. In the "Insert" menu, choose the option "Chart" or click on the icon "Chart Wizard" in the toolbar. To create a bar chart with the default settings, press F11 after isolation cell. The histogram is created on a separate sheet.


Choose from the list the type "histogram". In the "Type" select its subtype. Tip-description is displayed in the bottom window that will help you make a choice. Click on the button "Output" to see how it will look like a bar graph based on your data. Go to the tab "Custom" if you want to create a custom bar chart - for example, in combination with the schedule and with the regions. Click "Next" to continue construction.


On the next screen you have to specify the rangedata for the histogram. By default, the entire table. Highlight those cells whose content should be displayed in the bar chart. In the "Range" dialog box, select the desired values. With the switch "in rows" to determine which option will be shown on the horizontal axis - the columns or rows. Click "Next" to continue.


In the "Chart Options" tab"Titles" enter the name of your bar graph and axes if you see fit. Passing through the tabs, you can draw a picture in accordance with the work that he has illustrated. The preview window shows all changes you make. To continue, click "Next".


In the last step specify the Excel editor, where youintend to place the histogram - to implement it in a worksheet or placed on a separate sheet. Set the switch to the desired value and click "Finish" to complete the work.

Comments are closed.