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.
You can change the colors on your Google Calendar by clicking the three dots next to each calendar's name.