Clustered Stacked Column Chart With Secondary Axis. In the data table insert column that is dedicated to free up space for stacked column and build clustered column. Click Clustered Column - Line on secondary axis.
Click Insert Combo Chart. Aug 21 2012 Heres how to get a stacked and clustered column bar chart done in excel tested on Excel 2011 for Mac. Apr 18 2016 Replies 5 1.
With the possibility to add another line to place on the second axis.
Right-click the Dept1 series and choose Format Data Series and on the first tab choose Secondary Axis 3. Do you know any workaround for this. Choose Chart Tools Format and open the Chart Element dropdown the very first tool on the top left of the ribbon. Select visible clustered column series press Ctrl 1.
