how to add a chart in 2016 excel for mac

Add A Chart In 2016 Excel Download Samples Files

Excel Histogram Chart A histogram is a column or a bar chart that represents values using a range.

In the class, she has 50 students and to present the performance of the class, she can use the distribution of students according to their marks using a histogram.

In this guide, Ill be sharing with you everything you need to master this chart.

Add A Chart In 2016 Excel Download Samples Files

So stay with me for the next few minutes Download Samples Files 2016 2013 Mac Pivot Other Steps to Make a Histogram in Excel 2016 If you are like me, using Excel 2016 Ive got good news for you and the good news is, there is an inbuilt option to create a histogram in this version of Excel.

Lets suppose you have a list of employees ( here is the list ) and their period of employment with the company.

And now you need to create a histogram which should show the number of employees in a particular period range (Bin).

Follow these simple steps: First of all, select the data and go to the Insert Tab Charting Insert Statistic Charts Histogram Histogram, to insert the chart.

In reality, this is the only step you need to follow, your chart is there in your spreadsheet.

Pro Tip When youre using Excel 2016 make sure to convert your data into an Excel table to make it dynamic.

So whenever you add new data into it, your chart gets updated automatically..download this sample file from here to learn more.

But now you need to have look at how can you customize it and all the options you have with it.

Lets explore some of the main options related to bins one by one: Now, select your charts axis and right-click on it and open Format Axis.

By Categories If you think about the data we are using here, every entry is unique as each employees name is different.

But if you have data where you have repetitive entries, then you can use this option to create a chart based on the SUM or COUNT of those categories instead of numeric bins.

In this case, the bins would be the categories not the distribution of numerical data.

Automatic When you create a histogram, Excel creates bins automatically using the range of the values you have.

In simple words, this option is the default way to make a histogram.

Bin Width By using this option, you can specify the width of the Bins.

Lets say if you want to make each bin have 10 then this will create each bin of 0-10, 10-20 and so on.

With this option you have control over the width of the bin and Excel will create the number of bins using width you specified.

Lets say you have values from 1 to 20 and you want bin width 4, then Excel will create 5 bins like this: 4.

Number of Bin And if you want to specify the number of bins instead of the range you can click on this option and enter the number.

Lets say if you want to have 3 bins and the range of values is 0-15 then Excel will create bins like: 5.

Overflow Bin Underflow Bin These two options help you to create more than or less than bins in the chart.

Let say, you want to have a bin for the employees with a working period of fewer than 10 years.

Or, if you want to have Bin for the employees having a working period of more than 20 years, enter 20 in the overflow.

How To Add A Chart In 2016 Excel For Mac