Click the "Series Options" icon, and change "Series Overlap" to 100% by clicking ... First, you need to make sure your chart includes data that is contained within hidden cells.

0–5 and 5–10 would not be sensible groups as there is an overlap and 5 belongs in two class intervals. Once finished, the table is known as a grouped frequency chart. Here is the data from a ...

and in the Format Data Point sidebar, click the "Series Options" icon. There, slide the Series Overlap value to "100%," and change the Gap Width to a value that works well on your chart (your ...