It is important to notice that you can also copy and paste the chart as an image, using Paste Special. Apply any chart template and then you can make your Histogram look really awesome and modern. For example, we may want to modernize the style by using one of the chart templates available in Microsoft PowerPoint 2010. This is our histogram sample in PowerPoint 2010, however we can move a step forward and change the styling. Here you can customize the chart design, format it or change the chart layout. You will see that the chart looks exactly the same, moreover you can also see the Chart Tools on the top of PowerPoint ribbon. How to Create the Histogram Chart in PowerPoint 2010Ĭopy the chart from Excel and paste it in a new slide in PowerPoint 2010. The first column is the input data and the second one are the bins. You can copy the data from How to use Histogram in Excel. Now, you can insert a sample table or data with the data and bins. Now, check the Analysis ToolPak option and then click OK. Look for the combo box at the bottom and click Manage Excel Add-ins and Go button. Go to Excel options and then choose Add-ins.

This add-in is great to add new analysis features for Excel spreadsheets, under the Data Analysis button in the menu making possible to run analysis and generate new charts for statistics and other useful applications including: Anova: Single Factor, Anova: Two-Factor with Replication, Anova: Two-Factor, Without Replication, Correlation, Covariance, Descriptive Statistics, Exponential Smoothing, F-Test Two Sample for Variance, Fourier Analysis, Histogram, Moving Average, Random Number Generation, Rank and Percents, Regression, Sampling, t-Test: Paired Two Sample for Means. In order to create a Histogram in Excel we will need to install an add-in named Analysis Toolpak.Īnalysis ToolPak is an add-in for Microsoft Excel that is available in Microsoft Excel 2010. Analysis ToolPak VBA is another variant that can be used with Macros, while the Analysis ToolPak is for interactive use.

Make a histogram in excel