There are 17 different types of charts in Excel, so it can sometimes be difficult to choose which one to use. In this article ...

We’ll chart this data using a combo chart. We’ll base a line chart on the data as follows: Click anywhere inside the data set, which is a Table object named Sales in this case.

Use Excel's chart wizard to make a combo chart that combines two chart types, each with its own data set. Select the two sets of data you want to use to create the graph.