Clustered Bar Chart Excel Mac. For example put the Q1 and Q2 data in separate rows and then insert blank row after each group of data row and header row please remember to delete the first cell header. Select the data and insert a bar char on the ribbon.
You can see the same data in a clustered bar chart. Move this year series up. Creating a combo chart with both columns and lines takes a few extra steps.
In the Plot Series On area click Secondary Axis.
Click on a bar that you want to appear in front. Insert the first 2D bar chart option. You can see the same data in a clustered bar chart. Click the Insert tab click Bar Chart and then click Clustered Bar in 2016 versions hover your cursor over the options to display a sample of how the chart will appear.
