How to Make Histograms in PowerPoint using Excel Charts

Using Excel and free Analysis Toolpak addin for Excel you can create useful histograms for your spreadsheets, but also use the resulting image to copy and paste the Histogram in PowerPoint presentations. Here we will show you how to make histogram charts for PowerPoint using Excel.

How to Make Histograms for PowerPoint using Excel

Here we will show you how to create a histogram chart in Excel and then use it in PowerPoint for your presentations. Finally, we will see how to apply the styles available in PowerPoint charts to make it impressive using the modern PowerPoint chart templates in PowerPoint 2013.

Create a Histogram in Excel

In order to create a Histogram in Excel we will need to install an add-in named Analysis Toolpak.

Analysis 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. 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.

Go to Excel options and then choose Add-ins. Look for the combo box at the bottom and click Manage Excel Add-ins and Go button.

histogram

Now, check the Analysis ToolPak option and then click OK.

excel histogram analysis toolpak

Now, you can insert a sample table or data with the data and bins. You can copy the data from How to use Histogram in Excel.

The first column is the input data and the second one are the bins.

8720
2740
4560
6280
3
52
20
43
74
61

Now look for the Data Analysis button in Excel, that should appear under Data menu. Here we will create a Histogram in Excel.

Tip: If you already have the frequency in the tabular data, then you can easily create a Histogram using the simple Bar chart in Excel or PowerPoint.

histogram ppt

In the Data Analysis dialog, under Analysis Tools choose Histogram from the list and click OK.

histogram powerpoint

Now, select the input range with the data on the first column and then the bin range with the second column.

Make sure to check the Chart Output since this will indicate that we want to generate the chart. You can also use cumulative percentage or the Pareto style (sorted histogram).

histogram excel

Click OK and now we will see the Histogram chart in Excel.

histogram sample excel

Now with the chart we have created in Excel we are ready to use it for our PowerPoint presentations or PowerPoint templates.

Analysis Toolpak is a powerful add-in that most people may not be aware of, and allows you to use Excel as a statistical or engineering platform for analysis. In fact, to use these tools you need to be familiar with the specific area of statistics or engineering that you want to develop analyses for. You can learn more about Analysis Toolpak and Excel functions in this website.

How to Create the Histogram Chart in PowerPoint 2010

Copy the chart from Excel and paste it in a new slide in PowerPoint 2010. You will see that the chart looks exactly the same, moreover you can also see the Chart Tools on the top of PowerPoint ribbon. Here you can customize the chart design, format it or change the chart layout.

histogram example powerpoint 2010

This is our histogram sample in PowerPoint 2010, however we can move a step forward and change the styling. For example, we may want to modernize the style by using one of the chart templates available in Microsoft PowerPoint 2010. Apply any chart template and then you can make your Histogram look really awesome and modern.

modern histogram design

It is important to notice that you can also copy and paste the chart as an image, using Paste Special.

More about Histograms and Charts

As you can see, the difference between histogram and bar chart is just about the input data and frequency count. In the histogram,

Normally in Histograms there is no gap between the columns. You can do that in PowerPoint if you really need to remove the gap. For this purpose, you can access the Format Data Serie dialog and then look for the Gap Width option. Choose No Gap on the left or 0% gap and it will remove the space between the bar chart in PowerPoint histogram.

If you need to use this similar chart template we have saved the .crtx chart template for your convenience and you can download it here. This chart template is compatible with Microsoft Excel 2010 and Microsoft PowerPoint 2010.

Alternatively to this solution you may want to check the free histogram online generators as well as other solutions for example to design your own histogram manually using shapes in PowerPoint. However, this may not be a good solution if you are looking for an accurate solution. Finally, if you need to update the histogram chart automatically from the data that you change in Excel then you can learn more in how to update automatically the chart from Excel into PowerPoint 2010.

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

Leave a Comment

Your email address will not be published. Required fields are marked *