Home / the Internet / Software / How to build a histogram in Excel

How to build a histogram in Excel


How to build a histogram in Excel</a>

The histogram is a graph, the data in which are displayed in the form of columns.

The height of the columns depends on the amount of data, and the interval between them depends on the time interval during which the data was collected.



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


Select an arbitrarily selected cell from thisTables. In the "Insert" menu, select the "Chart" option or click on the "Chart Wizard" icon on the toolbar. To create a histogram with the default settings, after selecting the cell, press F11. The histogram will be created on a separate sheet.


Select the "Histogram" type from the list. In the "Type" section, specify its subtype. In the lower window, a description hint is displayed, which will help you make a choice. Click on the "Result" button to see how the histogram will look based on your data. Go to the "Custom" tab if you want to create a custom histogram - for example, in combination with a chart or with areas. To continue building, click "Next".


In the next window you must specify a rangeData to build a histogram. The default is the whole table. Select the cells whose contents should be displayed in the histogram. In the "Range" field of the dialog box, specify the required values. Using the "Rows in" switch, determine which parameter will be indicated on the abscissa - columns or rows. Click "Next" to continue.


In the "Chart Settings" window on the tab"Headers" indicate the name of your histogram and axes, if you deem it necessary. Moving on the tabs, you can draw a picture in accordance with the work that he should illustrate. The preview window displays all the changes you make. Click "Next" to continue.


In the last step, specify the Excel editor where youSuppose you want to place a histogram-insert it into a worksheet or place it on a separate sheet. Set the switch to the desired value and click "Finish" to complete the work.

How to build a histogram in Excel Was last modified: June 21st, 2017 By Wezhyold
It is main inner container footer text