How to create a "combination chart" ?

JP_ZhangTo create a combination chart, you need to select the ranges that your data is in and go to the insert tab. On the Insert tab, in the Charts group, there is a combo symbol that you must click. This symbol has a line graph above a bar graph (it is in the second row to the left of the PivotChart symbol). Once you click on the combo symbol, the chart dialogue box will appear. From here since you want a custom combination chart, you need to click the combo symbol with a blue pencil. This will allow you to customize where you want your data to be placed or what you wish to as a line or bar graph. Finally, to see your results, you will click to OK, which is located at the bottom of the dialog box. I hope this helps!