![how to insert a histogram in excel 2016 how to insert a histogram in excel 2016](https://cdns.tblsft.com/sites/default/files/pages/bin_histogram_tableau.png)
#HOW TO INSERT A HISTOGRAM IN EXCEL 2016 HOW TO#
How To Make A Histogram In Excel 2016 For Mac Download Click the little button to the right of the empty field.ĭrag over the cell range that has your values, but do not include the data label. Note that the Horizontal (Category) axis labels field in the dialog is blank. Click anywhere on your chart to activate the Chart Design tab. If you don't see the Chart Design tab in the Ribbon, you clicked away from the chart. From the Chart Design tab of the Ribbon click the Select Data button. Next, we need to put the proper values in the x-axis. Values no longer display and Frequency columns remain visible. Jump to Creating the Histogram on Mac - It's the set of blue columns below the 'Histogram' heading. At the end of the article, for example, see an example of these steps for Excel for Mac 2011. Excel 2007, 2010, and 2011 for Mac all have tested using this technique. The screenshots and directions presented here are from Excel 2013 however, previous versions of Excel can easily create histogram through these same methods.
#HOW TO INSERT A HISTOGRAM IN EXCEL 2016 INSTALL#
To create a histogram in the Mac version of Excel we need to install “Analysis Tool Pack” as well. You can click on the Frequency label and press delete if you want to tidy things up.
![how to insert a histogram in excel 2016 how to insert a histogram in excel 2016](https://sumproduct-4634.kxcdn.com/fileadmin/_processed_/0/8/csm_image4_5c639718a8.png)
Click the OK button to close the Source Data dialog box. Excel fills in the dialog box for you, but you might have to click into the empty field to get the display to refresh. Using our example, you would select the range B2:H2. Your chart should look something like this with the Value measure selected: 6. Little round 'handles' will appear on all of the columns to indicate they are selected. In this example, the Value row is represented by the taller columns. Click once on any of the columns measuring Value.
![how to insert a histogram in excel 2016 how to insert a histogram in excel 2016](https://cdn.ablebits.com/_img-blog/histogram-excel/customized-excel-histogram.png)
In the Charts group on the Ribbon, click the Recommended Charts button. Select any cell within the range of cells that includes the data. Type this into a blank worksheet: Follow these steps to make a really great looking histogram.