Use Data Analysis Toolpak: Excel’s Data Analysis Toolpak offers a built-in histogram tool that can simplify the process. Make sure to enable it from the Add-ins menu.

In such cases, you can add space by indenting the data in one of the columns. You can also increase the space between columns in your Excel chart using the Data Series formatting tool. Data Columns ...