Right-click the blue series, so that all of the blue columns are selected, and from the Chart Tools Format tab, select the No Fill option, which for all intents and purposes, makes the blue series disappear (see Figure 2 below).įigure 2: Resulting formatted Blue Series Hiding the Base Columns: Next, let's do the same with the Base columns.So right-click the green series, so that all of the green columns are selected, and from the Chart Tools Format Tab in the Ribbon, select the No Fill option, which for all intents and purposes, makes the green series disappear (see Figure 1 below).įigure 1: Chart Tools Format tab - Green Series
