For instance, you can create a chart that displays two unique sets of data. Use Excel's chart wizard to make a combo chart that combines two chart types, each with its own data set.

By default, two sets of numbers may result in Excel's red and blue color scheme, such as when you do a column or bar chart.

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.