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.