When you have such sheets which should be grouped, but they cannot be put next to each other, you can use colors. First, select them using Ctrl, and then right-click on any of them. In the menu, you ...
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.