Knowledge Base

How to Create a Histogram in Excel

This isn’t specific to our software, but it’s a question that comes up a lot. How to create a histogram in Excel? Or more specifically, how to go from a standard bar graph:

to a histogram:

It’s very simple to do. Right-click on one of the bars and select Format Data Series. Under Series Options, you’ll see a slider for Gap Width. Set that to zero for a classic histogram.

You can use the other settings in this window to make the chart arbitrarily fancy:

Search the Knowledge Base

Structured Data LLC

Structured Data LLC is a software services and consulting firm founded in 2005, with offices in New York and San Francisco.

More Information?

If you'd like more information, please enter your email address below and we will get in touch.

Contact Us