Clustered Column Combo Chart. This video shows you how to create Combo Chart Clustered Column Line on Secondary Axis in MS Excel 2013Excel Tips. Insert tab on the ribbon.
Create a Clustered column Line on secondary axis chart in the Sheet1 worksheet deriving data from the cell range 1C4Want more. Click the Quick Analysis Tool button and then click the Charts tab. To do that we need to select the entire source Range including the Headings.
For the red series copy the range B8C11.
Step 1- First select the data table prepared then go to the insert tab in the ribbon click on Combo and then select clustered column line. Clustered columns and lines. The default Combo Chart combination is Clustered Column for the first data series and Line for the second data series. Create a Clustered column Line on secondary axis chart in the Sheet1 worksheet deriving data from the cell range 1C4Want more.
