The Data Analysis Toolpak must be installed before you can use itĮxcel does not come with a Histogram tool normally. To use it, you’ll need to download and install the Analysis ToolPak Add-in for Excel.
The Histogram will appear in the column of Analysis Tools or in the charts section once the Add-in is enabled. Select the ‘File’ button in Excel to add the Analysis ToolPak Add-in.Choose ‘Options’ in the Excel backstage window.Hit the ‘Add-ins’ button on the left side of the ‘Excel Options’ window.You can edit and see your Microsoft Excel Add-ins there.Next, in the Add-ins dialogue box, select the ‘Analysis ToolPak’ option and tap on ‘OK.‘.Ĭhoose ‘Go’ after selecting ‘Excel Add-in’ from the ‘Manage:’ drop-down at the bottom left of the screen.Now that Excel has a histogram feature, let’s look at how to make one. The Process of Using Charts to Make a Histogram #Histogram maker excel how to Generate a database and pick the number of cells that contain the statistics that will be shown as a histogram.Build a dataset for a group of students in ten classes, for instance.Visit the ‘Insert’ tab and choose the range of cells you want to input.The histogram chart format is now accessible in the Insert tab’s ‘Charts’ category. Pick your histogram template by clicking on the histogram logo.
