How to Create a Histogram in PowerPoint

Using the chart options available in PowerPoint, you can turn your data into a histogram. You will need the appropriate data, normally presented as Bin and Frequency. For example, to display a histogram of student grades, the grades would be the Bin data and the number of students with each grade would be the Frequency. You can also paste an Excel-created histogram directly into PowerPoint and then customize the chart.

Video of the Day

Creating a Histogram in PowerPoint

Click the Chart icon.
credit: Screenshot courtesy of Microsoft.

Select the PowerPoint slide where you want to insert the histogram. Make sure the data you need for the histogram is nearby, then click the Insert tab and select the Chart icon.

Create a Stacked Column chart.
credit: Screenshot courtesy of Microsoft.

Click the Columns option in the Charts window and select the Stacked Column chart, which is the second icon. This is the easiest chart to customize for a histogram. When the chart opens, an Excel-like worksheet appears above the chart.

Delete the data for Series 2 and Series 3.
credit: Screenshot courtesy of Microsoft.

Drag the cursor across the cells containing the data for Series 2 and Series 3 and press Delete to remove data from the columns.

Enter your histogram data in columns A and B.
credit: Screenshot courtesy of Microsoft.

Replace the data in Column A, beginning with cell A2 with the Bin data for your histogram. Replace the data beneath Series 1, beginning with cell B2, with your Frequency data. The chart now looks exactly like a histogram produced by Excel's Histogram data analysis.

Edit the chart as desired.
credit: Screenshot courtesy of Microsoft.

Customize the chart as desired by clicking the icons in the upper-right corner. For example, to remove the Chart Legend below the chart, click the + icon and then clear the Legend check box. You can change the Chart Title by clicking it and typing a new title, or clear the Chart Title check in the + icon's drop-down menu.

Importing a Histogram From Excel

Copy a histogram in Excel.
credit: Screenshot courtesy of Microsoft.

If you don't already have the histogram data, follow the Techwalla tutorial to . When you're done, you will have a histogram chart. Right-click the chart in Excel and select Copy from the drop-down menu.

Paste the histogram in PowerPoint.
credit: Screenshot courtesy of Microsoft.

Open PowerPoint and select a slide. Press Ctrl-V to paste the chart in the slide. After it has been inserted, you can edit the chart as you would any chart you created in PowerPoint from scratch.

Show Comments