Data >> Science >> Visualization >> How to display a histogram of data in Excel with a specific number of bins (bars)

 

   
The Data and the Visualization required
Select the data including the header
Select "Insert" from the main menu
Drop down and select Histogram
Select the horizontal axis area until it is highlighted,
Right click and select Format Axis
Set the "Number of bins" accordingly
Resulting chart