Combo charts combine more than one Excel chart bang out in the same chart.
Note: I learned the error bar approach fromExcel chart guru Jon Peltier.
Column chart with target line
Combo charts combine more than one Excel chart type in the same chart. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value. In the chart shown in this example, daily sales are plotted in columns, and a line shows target sales of $500 per day.
