Select the drop-down arrow and choose Line.Īdd or remove a secondary axis in a chart in Office 2010 Select Secondary Axis for the data series you want to show. Select Combo > Cluster Column - Line on Secondary Axis. Note: The following procedure applies to Office 2013 and newer versions.