How do I do a histogram in Excel 2010? Make a histogram using Excel's Analysis ToolPakOn the Data tab, in the Analysis group, click the Data Analysis button.In the Data Analysis dialog, select Histogram and click OK.In the Histogram dialog window, do the following: ... And now, click OK, and review the output table and histogram graph:11 mei 2016