Clustered Column Line Combo Chart. 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. Go to tab Insert.
You can set a different chart type for each data series. On the All Charts tab choose Combo and then pick the Clustered Column - Line on Secondary Axis chart. Find Charts-Insert Column Chart.
You could try to put field which have negative value in column Or another workaround is that you could create another measure for this Measure 2 if SUM Table q20 SUM Table q2 BLANK.
The default Combo Chart combination is Clustered Column for the first data series and Line for the second data series. May 11 2020 Select your data click Insert-Charts group-PivotChart after selecting and dragging PivotChart Fields as you need right click on the chart and select Change Chart Type then select Combo-Clustered Column. In the Chart in Microsoft PowerPoint dialog box. And select the first type.
