Stacked bar charts have a specific function. They're the best-possible way to visualize data in these situations.

Stacked bar chart filling up to 100% Sometimes, you’ll want to compare your data to a total, be it a whole number or simply a 100% value.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.