Learn how to create a Combination Chart in Microsoft Excel. ... Clustered Column -Line on Secondary Axis: This chart type is used when the chart’s range varies widely and has mixed data types.