Output Option: Select the “New Worksheet” for the output and tick mark the “Chart Output” for the chart.Bin Range: The range where you have bins, yes the one we have just created (Make sure to only select the values without heading).Input Range: The range where you have employee years with the company (Make sure to only select the values without heading).Once you click OK, you’ll have the histogram dialog box where you need to enter the following:.From the data analysis window, select “Histogram” and click OK.First of all, go to the data tab and click on “Data Analysis” button.Step to Create a Histogram īefore you create your chart, make sure to create the bins as we have made in the above method.Īnd, if you don’t know about the Bins, make sure to read about them in the above section of this post. This will instantly add the “Data Analysis” button into the Data Tab.
To create a histogram in the Mac version of Excel we need to install “Analysis Tool Pack” as well.
When you create a histogram using “Analysis Took Pack” you can’t undo it, you need to delete it and create a new one if you want to make changes.Ĭreating a Histogram in the Excel for Mac.If you skip specifying the bins, it will automatically choose bins and creates the chart.When you add a new value in the main data it will not update it, so you need to create a new chart. “Analysis Took Pack” creates a chart that is not dynamic.Even if you don’t have a value greater than the last bin it adds “More” as a bin. Apart from the bins you create, it adds an extra bin with the name of “More” to show values more than the last bin.