If you use a Mac, to activate the analysis tools you have to go to the menu Tools> Excel Add-ins located at the top, you must put the check mark next to the item Analysis tools and you have to press the button good.Īt this point, go to the card data from the Excel toolbar click the button Analysis of data (bottom right) and select, by double-clicking on it, the item histogram from the list that appears. In the window that opens, select the item Additional components from the left sidebar, click on the button vai (below), put the check mark next to the item Analysis tools - VBA and click on the button good to activate data analysis in the form of histograms. If you do not want to create a simple histogram but want to analyze the data and frequencies contained in a spreadsheet using this type of graph, you must click the button office hour located in the upper left and select the item Options from the menu that appears.

You can move the chart and resize it freely with the mouse, while to customize it (for example, change the colors of the bars) you must click on it and use the form tools Graphical tools that appears on the Excel toolbar. At this point, almost like magic, your graph will appear in the spreadsheet with the selected data in the cells. Then click on the button histogram contained in the card enter Excel (the one with three vertical bars ) and select the type of graphic you want to use through the box that appears. The data should be organized in two columns: on the one hand, i data to be analyzed and on the other i bin data, which represent the intervals to measure the frequency. If you want to learn How to make a histogram with Excel and use a recent version of Office for Windows or macOS, the first step you should take is to start standing out and open in it the spreadsheet that contains the data you want to draw your chart.Īt this point, you must hold down the left mouse button and select all the cells that contain the data you want to display in the box (for example, the answers given to a survey and how often they were given).

How to combine histograms in excel